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