5 of 5
Paper No: 10
Write a query to display airline_id, airlineName, NumberOfFlights corresponding to the airlines having more NumberOfFlights than all the three airlines named 'Vietnam Airlines','Air France' and 'Lufthansa Airlines'; where, for each airline:
- airline_id and airlineName are respectively the id and the name of the airline.
- NumberOfFlights is the total number of flights operated by the airline.
airline_id
airlineName
NumberOfFlights
4
5
7
China Eastern Airlines
20
2
Malaysia Airlines
20
3
British Airways
24
4
8
Hong Kong Airlines
5
10
Singapore Airlines
27
6
12
American Airlines
28
7
15
United Airlines
22
21
8
16
Emirates Airlines
22
1
Question 7:
Picture 6.1
Zoom
Write a query to display booking_platform_id, booking_platform_name,
+ 82%
Close
