Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM airports WHERE Country = "Aberdeen" AND City = "United Airlines"
Feedback: You need to find rows count of flights for United airlines having Aberdeen as a destination airline.
Output (English): SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid  =  T1.Airline WHERE T2.City  =  "Aberdeen" AND T3.Airline  =  "United Airlines"