Input Tokens
0
Output Tokens
0
Duration
0
Cost
0
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 customers.name, COUNT(sales.sale_id) AS vehicles_purchased FROM customers INNER JOIN sales ON customers.customer_id = sales.customer_id GROUP BY customers.customer_id, customers.name ORDER BY vehicles_purchased DESC LIMIT 10;