Duration
39s
Input Tokens
785
Output Tokens
2593
Cost
$0.00
Context
Input
Show the names of customers who paid more than the average sale price for the vehicles they bought.Expected output
SELECT c.name FROM customers c JOIN sales s ON c.customer_id = s.customer_id WHERE s.sale_price > (SELECT AVG(s2.sale_price) FROM sales s2 WHERE s2.vehicle_id = s.vehicle_id);Model output
WITH customer_sales AS (\n SELECT c.customer_id,\n c.name,\n s.sale_price,\n AVG(s.sale_price) OVER (PARTITION BY c.customer_id) AS avg_price_by_customer\n FROM customers c\n JOIN sales s ON s.customer_id = c.customer_id\n)\nSELECT DISTINCT name\nFROM customer_sales\nWHERE sale_price > avg_price_by_customer\nORDER BY name;