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

select c.name as customer_name, sum(price) as total_travel_cost, count(p.id) as order_count, round(avg(price), 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 like '2024%'
group by c.name
having sum(price) > 10000
order by total_travel_cost desc

其实不应该对的，可能有非2024年的信息。理论上来说，应该要先筛选2024年总费用>10000的人，再进行订单数和平均价格的计算。题目具体也没有说清楚。