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.

Transcribed Image Text:

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 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