SQL Generation

Turn plain-English questions into correct SQL against a schema. The skill behind analytics chat, natural-language dashboards, and 'just ask the database' interfaces.

100
Duration
4s
Input Tokens
1026
Output Tokens
122
Cost
$0.01
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 dealerships d JOIN sales s ON d.branch_id = s.branch_id GROUP BY d.branch_id, d.name ORDER BY SUM(s.sale_price) DESC LIMIT 1;