Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the SQL code for: Display departing airport code as Departs From, arriving airport code as Arrives at, and minimum fair as Minimum Fair,
What is the SQL code for: Display departing airport code as "Departs From", arriving airport code as "Arrives at", and minimum fair as "Minimum Fair", for flights that have minimum fare for flights between these two airports. based on the ERD attached.
PAS ITINERARY NO PAS_NAME PAS_FARE NUMBER PAS_CONFIRM_NO NUMBER TIC_ITINERARY_NO TIC_FLIGHT_NO TIC FLIGHT DATE TIC_SEAT pil pilot_id pil_pilotname pil_ssn pil_street pil_city pil_state pil_zip pil_flight_pay pil_brthdate pil_hiredate Passenger 1 Is for Pass M Ticket Pilots 1 1 1 Passenger reserves Is for departure Flys M M Reservation Is for departure 1 Departures M Uses RES CONFIRM_NO RES_DATE RES_NAME RES_PHONE Equip_type RES_FLIGHT_NO RES_FLIGHT_DATE DEP FLIGHT NO DEP_DEP_DATE DEP_PILOT_ID DEP_EQUIP_NO Flight M departures 1 EQ_EQUIP_NO EQ_EQUIP_TYPE EQ_SEAT_CAPACITY EQ_FUEL_CAPACITY EQ_miles_per_gal Airport Org Dest M Flight air_code air_location air_elevation air_phone air_hub_airline fl_flight_no fl_orig fl_dest fl_orig_time fl_dest_time fl_meal fl_fare fl_time_zones
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