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