Due to temporary maintenance at LaunchPad 'Beta', this pad is not suitable for flights involving drones with a maximum payload of more than 150 kg.
The logistics manager needs to find out the client's name, flight date, and departure time for all bookings made at LaunchPad 'Beta' for flights where the maximum payload of the drone can exceed 150 kg.
Study the database schema below and write an SQL query to retrieve this information. The results must be displayed in date order.
| ModelID | Manufacturer | MaxPayloadKg | RangeKm | HourlyRate |
|---|---|---|---|---|
| Osprey-9 | AeroViron | 200 | 150 | 120.00 |
| Swift-Flyer | SkyTech | 80 | 50 | 45.00 |
| Titan-X | HeavyLift | 500 | 300 | 350.00 |
| Dart-Mini | SkyTech | 12 | 20 | 25.00 |
| CargoMaster | AeroViron | 150 | 100 | 95.00 |
| BookingID | ModelID | LaunchPad | FlightDate | DepartureTime | ClientName |
|---|---|---|---|---|---|
| BK102 | Osprey-9 | Beta | 2025-11-12 | 08:30 | BioLabs |
| BK105 | Swift-Flyer | Alpha | 2025-11-12 | 10:00 | ApexCorp |
| BK109 | CargoMaster | Beta | 2025-11-12 | 11:15 | Zenith |
| BK112 | Titan-X | Gamma | 2025-11-13 | 14:00 | GlobalLog |
| BK115 | Osprey-9 | Beta | 2025-11-13 | 09:45 | BioLabs |