The current database is shown in outline notation below.

AIRLINE $($AirlineID$,$ AirlineName$)$

FLIGHT$($TripID$,$ Year, Month, Day, DayOfWeek, AirlineID, FlightNum, OrigAirport, DestAirport, DepartPlan, DepartDelay, TimePlan, TimeElapsed, TimeInAir, Distance, ArrivalPlan, ArrivalDelay$)$

OrigAirport foreign key to AIRPORT

DestAirport foreign key to AIRPORT

AIRPORT$($AirportID$,$ AirportName, StateAbbr, County, City, Longitude, Latitude$)$

StateAbbr foreign key to STATE

STATE $($StateAbbr$,$ StateName$)$

According to this design, write SQL queries to display the information for each of the following questions $($for the queries that need "join" operations, use the Cartesian join$).$

$[15$ pts$]$ Show the airline ID$,$ the origin airport ID$,$ the scheduled departure time, the departure delay in minutes, the time elapsed for the trip, the arrival delay in minutes, and the route distance. The output should be sorted by the airline ID in ascending order first; then by the origin airport ID in descending order.

$[15$ pts$]$ Show the same information as part $($a$),$ but only for trips that have routes longer than or equal to $2000$ miles and shorter than or equal to $3000$ miles.

$[15$ pts$]$ Show the same information as part $($b$),$ replacing the origin airport ID with the airport name. The same sorting rule is applied to the output: by airline ID and then by the airport ID$.$

$[15$ pts$]$ Show the airline name, the days of week, and the average of the departure delay time in minutes, grouping by the days of week and the airline name without sorting.

$[20$ pts$]$ Show the same information as part $($d$)$ and the average of the route distances $($naming this field as AvgDist$),$ applying the same grouping and sorting rules, but only for the trips that depart from the airports whose longitudes are greater than $-120$ and whose latitudes are greater $25$ ; and that have routes longer than or equal to $1000$ miles.

$[20$ pts$]$ Show the same information as part $($e$)$ whose resulted rows have the average of the departure delay time greater than or equal to $10$ minutes.