Question: Database SQl Write a query that displays all the cities that a pilot has never flown too... show pilot full name, city name Class Passenger
Class Passenger passenger Id INT first_name VVARCHAR2 last_name VARCHARZ email VARCHAR2 date_of_birth DATE loyalty_id INT Booking ticketid INT flight_id INT seatNum VARCHARZ class_id INT passeger id INT class I INT class_type VARCHAR2 Loyalty loyalty_id INT loyalty Type VARCHAR2 Airport airport id INT location id INT Route Location LEDJO PILUA DATABASE PROJECT AIRLINE Flight flight_id INT departure_time TIME departure_date DATE status id INT arrival time TIME arrival_date DATE route id INT Status route_id INT Airline d INT departure_airport_id INT arrival_airport id INT location id INT country_name VARCHAR2 city_name VARCHAR2 code VARCHAR2 status id INT status_name VARCHAR(45) Airline Pilot airline id INT airline name VARCHAR2 "pilot I INT first_name VARCHAR(45) last_name VARCHAR(45) experience INT Flight Pilot flight_id INT pilot_id INT S airline_code VARCHARZ location id INT
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
