Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions