Use the ERD diagram provided to output the following table on Oracle SQL Developer using both of
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the ERD diagram provided to output the following table on Oracle SQL Developer using both of the following criteria... Both A & B should have the same output.
a) Using a SUB QUERY, display the flight number, originating airport, destination airport, departure time as "Departure Time", and arrival time as "Arrival Time" for flights not departing on May 17, 2017.
b) Using a SET OPERATION, display the flight number, originating airport, destination airport, departure time as "Departure Time", and arrival time as "Arrival Time" for flights not departing on May 17, 2017.
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: