Is there an airport with the name "London Gatwick"?
select * from airport where airport_name = "London Gatwick"
How many aircrafts movements happen at this airport?
select aircraft_movements from airport where airport_name = "London Gatwick"
Also, how many aircrafts is the airport associated with?
select count(*) from aircraft as t1 join airport_aircraft as t2 on t1.aircraft_id = t2.aircraft_id join airport as t3 on t2.airport_id = t3.airport_id where t3.airport_name = "London Gatwick"
What is its name?
select t1.aircraft from aircraft as t1 join airport_aircraft as t2 on t1.aircraft_id = t2.aircraft_id join airport as t3 on t2.airport_id = t3.airport_id where t3.airport_name = "London Gatwick"