Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started