Duration
18s
Input Tokens
581
Output Tokens
868
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(*) AS vehicles_purchased FROM sales s JOIN customers c ON c.customer_id = s.customer_id GROUP BY c.customer_id, c.name ORDER BY vehicles_purchased DESC, c.name ASC LIMIT 10;