SELECT
    c.name AS customer_name,
    SUM(p.price) AS total_travel_cost,
    COUNT(b.id) AS order_count,
    ROUND(AVG(p.price),2) AS avg_order_price
FROM
    bookings AS b 
    INNER JOIN
    packages AS p ON b.package_id=p.id
        INNER JOIN
        customers AS c ON b.customer_id=c.id
WHERE
    YEAR(b.booking_date)=2024
GROUP BY
    c.name
HAVING
    total_travel_cost>10000
ORDER BY    
    total_travel_cost DESC;