SELECT pilot FROM flight GROUP BY pilot ORDER BY count(*) DESC LIMIT 1
which pilot is in charge of the most number of flights?
SELECT pilot FROM flight GROUP BY pilot ORDER BY count ( * ) DESC LIMIT 1
select pilot from flight group by pilot order by count ( * ) desc limit value
which pilot is in charge of the most number of flights ?