This is the flight and airline table
There are two airline with the most number of flights where is EA1709 and SA1865, can find the most number only, how do I find the Airline with the most number of flights.
Here is my query:
select max(y.total_flight) as most_number_of_flights
from (select Airline_ID, count(Flight_ID) as total_flight
group by Airline_ID)y group by Airline_ID;