-- Database schema
| airlines : uid [ INT ] primary_key , Airline [ TEXT ] , Abbreviation [ TEXT ] , Country [ TEXT ] | airports : City [ TEXT ] , AirportCode [ TEXT ] primary_key , AirportName [ TEXT ] , Country [ TEXT ] , CountryAbbrev [ TEXT ] | flights : Airline [ INT ] primary_key , FlightNo [ INT ] , SourceAirport [ TEXT ] flights.SourceAirport = airports.AirportCode , DestAirport [ TEXT ] flights.DestAirport = airports.AirportCode |
-- -- Count the number of United Airlines flights that arrive in Aberdeen.

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";