Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM airports WHERE City = "Aberdeen"
Feedback: in flights table sourceairport's equivalent city is aberdeen look for such rows number.
Output (English): SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport  =  T2.AirportCode WHERE T2.City  =  "Aberdeen"