Please solve these and also explain how to do them. $2|$l$|$ AMOOEL

PK MOD$\_$CODE

MOD$\_$MANUF

MOD$\_$NAME

MOD$\_$SEATS

MOD$\_$CHG$\_$MILE

$1|$l$|$ ARCRAFT

P$.$ REFERENCESD PK AC$\_$NUMBER

MOD$\_$CODE

AC$\_$TTAF

AC$\_$TTEL

AC$\_$TTER

CHAR$\_$FUEL$\_$GALLONS CHAR$\_$OIL$\_$QTS CUS$\_$CODE$1.$ Write a query that will list all the charter flights. Display the ac number, model name, charge per mile, distance, total flight cost $($charge per mile $*$ distance$),$ and destination. Display the balance as currency with $2$ decimal places. Sort the results in ascending order by the destination. $2.$ The airport manager wants to know the total distance flown and number of flights for each destination. The manager only wants to see those in which the Total Distance is greater than the average distance for all flights. Order the results in ascending order by charter destination. HINT: you will need to use a subquery on the having line. $3.$ Due to increasing gas prices, the cost of larger flights will increase by $5\mathrm{.}5\%.$ Write a single SQL command to increase the charge per mile for all airline models with $10$ seats or more. Show the update statement and a screen shot of the number of rows update and then select the updated rows and show them in your screen shot. $4.$ Write a single query that will delete employee $104$ and employee $101$ from the employee table. You will get an error message when executing. Explain the error message. $5.$ Write a query that will display the number who have earned each rating type. Display the rating name, the rating code and the count. Display the results in descending order by the count$\mathrm{.}6.$ For all flights on $2/5/2016,$ display the char$\_$date, ac$\_$number, char$\_$dest, char$\_$distnace, char$\_$hours$\_$flow, and the Flight Cost $-$ calculated using the fuel$\_$gallons $*$ chg mile. Display the flight cost as currency with $2$ decimal places. $7.$ You are interested in looking at all flights to $"$STL$".$ You want to know the total distance and the total hours flown by aircraft number for all flights to STL$.8.$ For each employee, display their length of employment, using their hire date year and the current date. Display those who have been employed for $10$ or more years. Sort the rows in descending order by length of employment.