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

select c.name as customer_name
,SUM(price) as total_travel_cost
,count(*) as order_count
,ROUND(avg(price),2) as avg_order_price
from bookings as b join packages as p on b.package_id = p.id
join customers as c on b.customer_id = c.id
where YEAR(booking_date) = '2024'
group by c.name
having total_travel_cost > 10000
order by total_travel_cost DESC;