which pilot is in charge of the most number of flights?
CREATE TABLE flight (pilot VARCHAR)
SELECT pilot FROM flight GROUP BY pilot ORDER BY COUNT(*) DESC LIMIT 1
### Context: CREATE TABLE flight (pilot VARCHAR) ### Question: which pilot is in charge of the most number of flights? ### Answer: SELECT pilot FROM flight GROUP BY pilot ORDER BY COUNT(*) DESC LIMIT 1