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