Question: Query 4 ) Eric's team is working on the pricing system and would like to review some flight information related to only flights that were
Query
Eric's team is working on the pricing system and would like to review some flight information related to only flights that were transporting family groups in February, see PassGroupType table
Note that passenger and group information is not needed, only flight data based on flights of family groups. Utilize a subquery to provide a filter for the flightID's that should be retrieved...remember the IN command?
Show the fields displayed in the example below.
Sort by FlightID
Label the query as Query
Example Results of first rows:
FlightID PickUpTime CostPerMile
::
::
::
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
