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

Input Tokens

993

Output Tokens

170

Cost

$0.00

Context

Input

List the names of employees and how many vehicles each of them has sold, including employees with 0 sales.

Expected output

SELECT e.name, COUNT(s.sale_id) AS vehicles_sold FROM employees e LEFT JOIN sales s ON e.employee_id = s.employee_id GROUP BY e.name ORDER BY e.name;

Model output

SELECT
  e.name AS employee_name,
  COUNT(s.sale_id) AS vehicles_sold
FROM employees AS e
LEFT JOIN sales AS s
  ON e.employee_id = s.employee_id
GROUP BY
  e.employee_id, e.name
ORDER BY
  e.name;