SQL

1. -Cities having more than one airport showing the name of the city and number of airports

2. -Airport offering international routes, showing the city where the airport is and the international destination

3. -Airport for which all departures are domestic showing the city where the airport is and all destination cities

4. -Airport serving both international and domestic flights showing the city where the airport is and all destination cities

5. -All cities having direct light to London showing the name of departure and arrival cities

z Rmove AIl Sort & Filter Records Name Nation Population Click to Add Belfas Chicago Denver Edmonton UK USA USA CA JP FR UK FR 330000 2700000 900000 1400000 175000 8700000 Le Havre London MontrealCA 1700000 12200000 8500000 2200000 1600000 640000 700000 4000000 13600000 650000 Moscow RS USA FR AU USA USA AU JP New York Perth Portland Seattle Vancouver CA