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

with t1 as(
    select customer_id,package_id,booking_date from bookings
    where year(booking_date) = 2024
)
select c.name customer_name,
sum(p.price) total_travel_cost,
count(customer_id) order_count,
round(sum(p.price)/count(customer_id),2) avg_order_price
from t1 join customers c on t1.customer_id = c.id
join packages p on t1.package_id = p.id
group by c.name
having total_travel_cost > 10000
order by total_travel_cost desc