Picture 5.1
Question 6:
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.
5 of 5
Paper No: 5
airline id
4
5
7
8
10
airlineName
NumberOfFlights
China Eastern Airlines 20
Malaysia Airlines
20
British Airways
24
27
Hong Kong Airlines
Singapore Airlines
American Airlines
28
22
21
22
1
2
3
4
5
6
7
8
Zoom
12
15
16
United Airlines
Emirates Airlines
Picture 6.1
+ 93%
Close
