SQL

Natural language to SQL query generation evaluates text-to-query fidelity and schema reasoning. This task is particularly relevant for analytics chat assistants and simplified database interfaces.

Duration

Input Tokens

955

Output Tokens

508

Cost

$0.00

Context

Input

For each dealership, rank employees by total sales amount in descending order. In the results I want to see dealership_name, employee_name , total_sales and sales_rank

Expected output

SELECT d.name AS dealership_name, e.name AS employee_name, SUM(s.sale_price) AS total_sales, RANK() OVER (PARTITION BY d.branch_id ORDER BY SUM(s.sale_price) DESC) AS sales_rank FROM sales s JOIN employees e ON s.employee_id = e.employee_id JOIN dealerships d ON s.branch_id = d.branch_id GROUP BY d.name, e.name, d.branch_id;

Model output

SELECT dealership.name AS dealership_name, employees.name AS employee_name, SUM(sales.sale_price) AS total_sales, ROW_NUMBER() OVER (PARTITION BY dealership.name ORDER BY SUM(sales.sale_price) DESC) AS sales_rank
FROM sales
JOIN dealerships ON sales.branch_id = dealerships.branch_id
JOIN employees ON sales.employee_id = employees.employee_id
GROUP BY dealership.name, employees.name;