Due to a mechanical restriction with the boat 'Hydra', the vessel cannot carry the specialized gas mixtures required for deep dives. Consequently, any excursions booked on the boat 'Hydra' to dive sites with a maximum depth of more than 30 metres must be flagged for rescheduling.
The dive centre manager needs to retrieve the diver's last name, the dive date, and the excursion time for all bookings made on the boat 'Hydra' for dive sites where the maximum depth exceeds 30 metres.
Study the database schema below and write an SQL query to retrieve this information. The results must be displayed in date order.
| SiteName | Difficulty | MaxDepthM | MarineLifeRating | Fee |
|---|---|---|---|---|
| Blue Hole | Expert | 45 | 5 | 120.00 |
| Coral Garden | Beginner | 12 | 4 | 45.00 |
| Shipwreck Cove | Intermediate | 35 | 5 | 85.00 |
| Sandy Shallows | Beginner | 8 | 2 | 30.00 |
| Shark Alley | Advanced | 40 | 5 | 150.00 |
| BoatName | SiteName | DiveDate | DiveTime | DiverLastName | InstructorName |
|---|---|---|---|---|---|
| Hydra | Blue Hole | 15/05/25 | 08:30 | Miller | Captain Jack |
| Zephyr | Coral Garden | 15/05/25 | 10:00 | Dupont | Captain Sarah |
| Hydra | Sandy Shallows | 15/05/25 | 13:00 | Tanaka | Captain Jack |
| Triton | Shipwreck Cove | 16/05/25 | 09:00 | Rossi | Captain Jack |
| Hydra | Shark Alley | 16/05/25 | 14:30 | Miller | Captain Sarah |