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

827

Output Tokens

550

Cost

$0.00

Context

Input

Find the name of the dealership that has the highest total revenue from vehicle sales

Expected output

SELECT d.name FROM dealerships d JOIN sales s ON d.branch_id = s.branch_id GROUP BY d.name ORDER BY SUM(s.sale_price) DESC LIMIT 1;

Model output

SELECT d.name FROM sales s JOIN dealerships d ON s.branch_id = d.branch_id GROUP BY d.branch_id, d.name ORDER BY SUM(s.sale_price) DESC LIMIT 1