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