Task: Text to Code
Input (English): How many flights depart from City Aberdeen?
Output (English): SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport  =  T2.AirportCode WHERE T2.City  =  "Aberdeen"