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
34s
Input Tokens
866
Output Tokens
2022
Cost
$0.02
Context
Input
Show the names of customers who paid more than the average sale price for the vehicles they bought.
Expected output
SELECT c.name FROM customers c JOIN sales s ON c.customer_id = s.customer_id WHERE s.sale_price > (SELECT AVG(s2.sale_price) FROM sales s2 WHERE s2.vehicle_id = s.vehicle_id);
Model output
SELECT DISTINCT c.name
FROM customers c
JOIN sales s ON c.customer_id = s.customer_id
WHERE s.sale_price > (
    SELECT AVG(s2.sale_price)
    FROM sales s2
    WHERE s2.vehicle_id = s.vehicle_id
)