Completed
Incomplete
Not Attended
Share
Epic Adventures Travel Agency books exciting vacations for customers. You manage the database for travel packages, destinations, and bookings.
Question - 1List all travel packages available at Epic Adventures.
Question - 2A customer booked 5 slots for the 'Mountain Escape' package. Update the available slots
Question - 3Add a new travel package named 'Cultural Tour' to Japan with 20 slots available at ₹100,000.00 each.
Question - 4Find the most expensive travel package available.
Question - 5Calculate the total revenue potential from all available travel packages.
Code Editor
Table Name: travel_packages
| id | package_name | destination | price | available_slots |
|---|---|---|---|---|
| 1 | Safari Adventure | Kenya | 120000.00 | 25 |
| 2 | Mountain Escape | Switzerland | 150000.00 | 10 |
| 3 | Beach Bliss | Maldives | 90000.00 | 30 |
>>> Submit Your Query to validate