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.

the follow up question is the only one i need u to do and i will paste it here below

NB!!!ONLY DO THE ONE BELOW

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.