mysql

Question 5 Answer saved Marked out of 4.00 Considering the table below, please answer the following questions below. CREATE TABLE FLIGHT_INFO AirCraftType varchar(20), Destination varchar(20), TimeOfDeparture varchar(20), DateOfDeparture DATE, Capacity varchar(20), FlightStatus varchar(20)) Write a statement to create a procedure that calculates and displays the average age of the passengers. Create a statement to invoke the procedure. Question 6 Answer saved Marked out of 10.00 Modify the procedure created in Question 5 to accept destination and total number of visits as input. The procedure must check if Germany was visited more than ten times, and then display the minimum age of the passengers. If Germany was visited less than ten times, display the maximum age of the passengers. Create a statement to invoke the procedure. Question 7 Answer saved Marked out of 2.00 Modify the procedure created in Question 6 to accept an input value. The result once processed should be returned as output for both conditions