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

825

Output Tokens

689

Cost

$0.00

Context

Input

List the names of employees and how many vehicles each of them has sold, including employees with 0 sales.

Expected output

SELECT e.name, COUNT(s.sale_id) AS vehicles_sold FROM employees e LEFT JOIN sales s ON e.employee_id = s.employee_id GROUP BY e.name ORDER BY e.name;

Model output

SELECT employees.name, COUNT(sales.sale_id) AS vehicle_count FROM employees LEFT JOIN sales ON employees.employee_id = sales.employee_id GROUP BY employees.name;