SQL Generation

Show the names of customers who paid more than the average sale price for the vehicles they bought.

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);

WITH avg_vehicle_price AS (
    SELECT vehicle_id, AVG(sale_price::numeric) AS avg_price
    FROM sales
    GROUP BY vehicle_id
)
SELECT DISTINCT c.name
FROM customers c
JOIN sales s ON c.customer_id = s.customer_id
JOIN avg_vehicle_price avp ON s.vehicle_id = avp.vehicle_id
WHERE s.sale_price::numeric > avp.avg_price;