-- 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 |
-- -- What are flight numbers of flights arriving at City "Aberdeen"?

SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport   =  T2.AirportCode WHERE T2.City  =  "Aberdeen";