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

990

Output Tokens

158

Cost

$0.00

Context

Input

List the top 5 most expensive services performed, showing vehicle make, model, and cost

Expected output

SELECT v.make, v.model, sr.cost FROM service_records sr JOIN vehicles v ON sr.vehicle_id = v.vehicle_id ORDER BY sr.cost DESC LIMIT 5;

Model output

SELECT
  T1.make,
  T1.model,
  T2.cost
FROM vehicles AS T1
INNER JOIN service_records AS T2
  ON T1.vehicle_id = T2.vehicle_id
ORDER BY
  T2.cost DESC
LIMIT 5;