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

833

Output Tokens

188

Cost

$0.01

Context

Input

Show the total sales revenue (total_revenue) per branch (branch_name)

Expected output

SELECT d.name AS branch_name, SUM(s.sale_price) AS total_revenue FROM sales s JOIN dealerships d ON s.branch_id = d.branch_id GROUP BY d.name;

Model output

SELECT d.name AS branch_name, COALESCE(SUM(s.sale_price), 0) AS total_revenue
FROM dealerships d
LEFT JOIN sales s ON s.branch_id = d.branch_id
GROUP BY d.branch_id, d.name
ORDER BY d.name;