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 4)
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, 2023(see PassGroupType table).
Note that passenger and group information is not needed, only flight data based on flights of family groups. Utilize a sub-query 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 4
Example Results of first 3 rows:
FlightID PickUpTime CostPerMile
9742023-02-0116:52:002.02
9752023-02-0204:41:005.92
9762023-02-0213:38:002.53

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!