4. Using a SET OPERATOR, display the IDs and names of pilots who are not currently...

Transcribed Image Text:

4. Using a SET OPERATOR, display the IDs and names of pilots who are not currently scheduled for a departure. FIL PILOT PIL PILOTNAME Moore, Sharon S. Tabor, Victor T. Knighton, Bill 1 SSM 2 VIT 3 WBK 5. Using a SUB QUERY, display the IDs and names of pilots who are not currently scheduled for a departure. FIL PILOT_IDFIL PILOTNAME 1 SSM 2 WBX 3 VIT Moore, Sharon S. highton, Bi11 Tabor, Victor T. 6. Using "IS NULL" and an OUTER JOIN, display the IDs and names of pilots who are not currently scheduled for a departure. FIL PILOT PIL PILOTNAME Moore, Sharon S. Tabor, Victor T. Knighton, Bi11 1 SSM 2 VIT 3 WBK 7. Display passenger name and seat number, as "Seat Number", for flight 101, departing on July 15, 2017 PAS NAME Seat Number 1 David Feterson 30 2 Hazel Peterson 30 3 Pete Peterson 3D 4. Using a SET OPERATOR, display the IDs and names of pilots who are not currently scheduled for a departure. FIL PILOT PIL PILOTNAME Moore, Sharon S. Tabor, Victor T. Knighton, Bill 1 SSM 2 VIT 3 WBK 5. Using a SUB QUERY, display the IDs and names of pilots who are not currently scheduled for a departure. FIL PILOT_IDFIL PILOTNAME 1 SSM 2 WBX 3 VIT Moore, Sharon S. highton, Bi11 Tabor, Victor T. 6. Using "IS NULL" and an OUTER JOIN, display the IDs and names of pilots who are not currently scheduled for a departure. FIL PILOT PIL PILOTNAME Moore, Sharon S. Tabor, Victor T. Knighton, Bi11 1 SSM 2 VIT 3 WBK 7. Display passenger name and seat number, as "Seat Number", for flight 101, departing on July 15, 2017 PAS NAME Seat Number 1 David Feterson 30 2 Hazel Peterson 30 3 Pete Peterson 3D