Duration
21s
Input Tokens
1021
Output Tokens
123
Cost
$0.00
Context
Input
Show customer names and the number of service records (as service_count) for their vehicles ordered alphabetically, only customers with service records (not 0)Expected output
SELECT c.name, COUNT(*) AS service_count FROM customers c JOIN sales s ON c.customer_id = s.customer_id JOIN service_records sr ON s.vehicle_id = sr.vehicle_id GROUP BY c.name ORDER BY c.name;Model output
SELECT customers.name, COUNT(service_records.record_id) AS service_count
FROM customers
JOIN sales ON customers.customer_id = sales.customer_id
JOIN vehicles ON sales.vehicle_id = vehicles.vehicle_id
JOIN service_records ON vehicles.vehicle_id = service_records.vehicle_id
GROUP BY customers.customer_id, customers.name
ORDER BY customers.name ASC;