The following tables form an instance of an Airport Database held in a relational DBMS: Airport (airportID, name, city, state, country) Carrier (carrierID, name, fleetSize, employees, revenue) Flight (carrierID, flightNo, date, time, airportID, destination, distance) Airnart - Each airport name is unique in its country. Carrier - Each carrier name is unique in the whole world. - Any (carrierID, flightNo) combination is unique for the whole day. 6. Display the number of airports. 7. Display the number of flights with distances longer than 3000 miles. 8. Display the number of all carriers and the average of their revenues. 9. Display the number of flights leaving from JFK and the total of their distances. 10. Display the minimum, the average, and the maximum distances of the flights that are scheduled on October 17 th, 2017