แสดงชื่อเครื่องบินที่เกี่ยวข้องกับทั้งสนามบินชื่อ "London Heathrow" และสนามบินชื่อ "London Gatwick"
Show the names of aircrafts that are associated with both an airport named "London Heathrow" and an airport named "London Gatwick"
df_airport = pd.DataFrame(columns=['Airport_ID', 'Airport_Name']); df_aircraft = pd.DataFrame(columns=['Aircraft', 'Aircraft_ID']); df_airport_aircraft = pd.DataFrame(columns=['Aircraft_ID', 'Airport_ID'])
set(df_aircraft[df_aircraft['Aircraft_ID'].isin(df_airport_aircraft[df_airport_aircraft['Airport_ID'].isin(df_airport[df_airport['Airport_Name'] == 'London Heathrow']['Airport_ID'])]['Aircraft_ID'])]['Aircraft']) & set(df_aircraft[df_aircraft['Aircraft_ID'].isin(df_airport_aircraft[df_airport_aircraft['Airport_ID'].isin(df_airport[df_airport['Airport_Name'] == 'London Gatwick']['Airport_ID'])]['Aircraft_ID'])]['Aircraft'])