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

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 b
join customers c on c.id=b.customer_id
join packages  p on p.id=b.package_id
where booking_date >= '2024-01-01' AND booking_date <= '2024-12-31'
group by  c.name
having sum(price)>10000
order by sum(price) desc;