Provide working SQL DML statements for the following database schema and queries

Table Flight

Table Airport

Table City

Table Plane

12683835148165324 67770 2a 7471 1112 1 DDPPK PSSDO 668961 1 0 DDNG RREE OODYSPO DDS unnu 0 5 198122251 7223 012345678 123456789 16208 321153211141111 1 NUFU UJUUUFJU FI U A U U A BF, st 3 TDYXR RRRDE NDGL C-B C D D K 1234567890123456789012 NameN Population Belfast UK Chicago US.A Denver USA Edmonton CA KyotoJP LondonUK Lyon FR Montreal CA Moscow RS New York USA 330000 2700000 680000 1400000 8700000 480000 1700000 12200000 8500000 2200000 1600000 640000 PerthAU Portland USA SeattleUSA Sydney AU Tokvo JP Vancouver CA 13600000 650000 Provide working SQL DML statements for the following EXERCISE 5database schema and queries CITY(Name, Nation, Population) AIRPORT(Code, City_FK, Nation_FK, NumTracks) FLIGHT(FlightID, DayOfWeek, DepartureAirport_FK, DepartureTime, ArrivalAirport_FK, ArrivalTime, Plane_FK) 1. 2. 3. 4. PLANE (ID, Type, NumPassengers, CargoSize) Cities with airport having multiple tracks Nations where flight UA472 departs and arrive Type of plane used for flights from Denver Plane type and num. of passengers used in flights departir from Chicago If plane description is not available, just show the type Cities with international flights departures 1. 5. 10 Provide working SQL DML statements for the following EXERCISE 5database schema and queries CITY(Name, Nation, Population) AIRPORT(Code, City_FK, Nation_FK, NumTracks) FLIGHT(FlightID, DayOfWeek, DepartureAirport_FK, DepartureTime, ArrivalAirport_FK, ArrivalTime, Plane_FK) PLANE (ID, Type, NumPassengers, CargoSize) Cities with direct flights from Seattle, sorted lexicographically 6. The number of international flights departing from Portland on Wednesday 7. The number of international flights departing every week from each US city 8. 9. Canadian cities having at least 2 direct flights to US 10. Cities served by the largest plane (as num. of passengers)