Hello, I have a homework, the question is attached.

1. Overview of the SQL language.
2. Data preparation: the Extraction, Transformation and Loading (ETL) process.
3. Data Warehouse, Data Governance.

Grand Travel Airlines Consider the following relational database for Grand Travel Airlines. Grand Travel Airlines has to keep track of its flight and airplane history. A flight is uniquely identified by the combination of a flight number and a date. Every passenger who has flown on Grand Travel has a unique passenger number. For a particular passenger who has taken a particular flight, the company wants to keep track of the fare that he paid for it and the date that he made the reservation for it. Clearly, a passenger may have taken many flights and every flight has had many passengers on it. A pilot is identified by a unique pilot number. A flight on a particular date has exactly one pilot. Each pilot has typically flown many flights. Each airplane has a unique plane number. A flight on a particular date used one airplane. Each airplane has flown on many flights and dates. PILOTN UM PI LOTNAM E BIRTH DATE HIREDATE PILOT Relation FLIGHTNUM DATE DEPTIME ARRTIME PlLQINLJJL/l PLANENLLM FLIGHT Relation PASSNAME ADDRESS W PASSENGER Relation FLI HTN M w PASSNQM FARE RESVDATE RESERVATION Relation MODEL CAPACITY YEARBUILT MANUF AIRPLANE Relation Write SQL SELECT commands to answer the following queries. 1. List the airplanes manufactured by Boeing. 2. How many reservations are there for flight 278 on February 21, 2014? 3. List the names and dates of hire of the pilots who flew Airbus A320 aircraft in March, 2014. 4. List the names, addresses, and telephone numbers of the passengers who have reservations on Flight 562 on January 15, 2004. 5. List the total fare paid by flight, for each flight scheduled to depart on December 23, 2013 whose airplane manufacturer was Boeing. Only list those flights for which the total fare was at least $5,000. 6. List the Airbus A3105 that have a passenger capacity greater than the smallest Boeing 737