These three tables are a part of an aviation database. They belong to an airline and...

Transcribed Image Text:

These three tables are a part of an aviation database. They belong to an airline and record the passengers on each flight. Passenger passenger D 100 101 name 100 100 101 101 101 Singh Raj So, Pokr PassengerOnFlight passenger to lighti 2345 2344 2340 2300 Flight contact phone flight10 +51400532452 +61400345777 class Business Business Business Economy Economy 2344 2345 2346 2300 2350 Result of Query: PassengerName So, Peter dep_airport MCL MEL BIOK SIN AIN 2 Flights ToBKK dest airport SIN MEL UKK Mr departure 18/07/2023 17:50 18/0//2023 12:20 23/06/2023 06:30 04/09/2023 40 12/102023 14 10 Law enforcement asks us to provide the information how many times Peter So has flown to Bangkok. We write a query that returns this result: As your answer, create a query that returns this result. mins 060 480 600 320 400 These three tables are a part of an aviation database. They belong to an airline and record the passengers on each flight. Passenger passenger D 100 101 name 100 100 101 101 101 Singh Raj So, Pokr PassengerOnFlight passenger to lighti 2345 2344 2340 2300 Flight contact phone flight10 +51400532452 +61400345777 class Business Business Business Economy Economy 2344 2345 2346 2300 2350 Result of Query: PassengerName So, Peter dep_airport MCL MEL BIOK SIN AIN 2 Flights ToBKK dest airport SIN MEL UKK Mr departure 18/07/2023 17:50 18/0//2023 12:20 23/06/2023 06:30 04/09/2023 40 12/102023 14 10 Law enforcement asks us to provide the information how many times Peter So has flown to Bangkok. We write a query that returns this result: As your answer, create a query that returns this result. mins 060 480 600 320 400

Answer rating: 100% (QA)

To retrieve the result showing how many times Peter So has flown to ... View the full answer