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.

Duration

29s

Input Tokens

604

Output Tokens

1177

Cost

$0.01

Context

Input

Show the top 10 customers who bought the most vehicles. List their names and how many vehicles they purchased (vehicles_purchased).

Expected output

SELECT c.name, COUNT(*) AS vehicles_purchased FROM sales s JOIN customers c ON s.customer_id = c.customer_id GROUP BY c.name ORDER BY vehicles_purchased DESC LIMIT 10;

Model output

SELECT
  c.name,
  COUNT(s.sale_id) AS vehicles_purchased
FROM customers AS c
JOIN sales AS s
  ON c.customer_id = s.customer_id
GROUP BY
  c.customer_id, c.name
ORDER BY
  vehicles_purchased DESC
LIMIT 10;