题解 | 查询高价值旅行套餐客户的支出与套餐详情

SELECT 
    c.name AS customer_name, 
    SUM(price) AS total_travel_cost, 
    COUNT(customer_id) AS order_count, 
    ROUND((SUM(price)/COUNT(customer_id)),2) AS avg_order_price
FROM 
    bookings b
    JOIN packages p ON b.package_id = p.id
    JOIN customers c ON b.customer_id = c.id
    where booking_date BETWEEN '2024-01-01' and '2024-12-31'
GROUP BY c.name
HAVING total_travel_cost > 10000
order by total_travel_cost desc;