Completed
Incomplete
Not Attended
Share
Orion Travel Agency is a premium travel service providing customers with curated
travel experiences worldwide. Each booking is recorded with a unique booking ID, customer
name, destination, travel date, and package cost. The travel manager wants to analyze
bookings: calculate total bookings, identify high-cost packages for promotions, and sort travel
schedules for operational planning. Your role is to write SQL queries using aggregate functions,
WHERE filters, and ORDER BY clauses to generate actionable insights for the travel team
Question - 1Display all bookings sorted by travel date.
Question - 2Filter bookings with package cost above 2800
Code Editor
Table Name: travel_bookings
| booking_id | customer_name | destination | travel_date | package_cost |
|---|---|---|---|---|
| 1 | Kabir | Paris | 2025-09-10 | 2500.00 |
| 2 | Nisha | London | 2025-09-15 | 3000.00 |
| 3 | Rohan | Tokyo | 2025-09-20 | 2800.00 |
| 4 | Isha | Sydney | 2025-09-25 | 3200.00 |
| 5 | Arjun | Dubai | 2025-09-30 | 2000.00 |
>>> Submit Your Query to validate