Duration
16s
Input Tokens
906
Output Tokens
1133
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
SELECT DISTINCT c.name FROM sales s JOIN customers c ON s.customer_id = c.customer_id JOIN (SELECT customer_id, AVG(sale_price) AS avg_price FROM sales GROUP BY customer_id) AS avg_sales ON s.customer_id = avg_sales.customer_id WHERE s.sale_price > avg_sales.avg_price;