ASAP Please write a SQL Query:

c. List the departure date and flight number that never got any personnel assigned.EMPLOYEE ASSIGNED_TO Employee_no Name 1001 John Jones 1002 Albert Peters 1003 Carl Rowe 1004 Phillips 1005 William Gates 1006

EMPLOYEE ASSIGNED_TO Employee_no Name 1001 John Jones 1002 Albert Peters 1003 Carl Rowe 1004 Phillips 1005 William Gates 1006 Robert Clark 1007 Joseph Warnock 1008 Lisa Stuart Employee_no dep_date 1001 Oct-31-2018 1003 Oct-31-2018 1004 Oct-31-2018 1002 Oct-31-2018 1007 Oct-31-2018 1003 Oct-31-2018 1004 Oct-31-2018 1005 Oct-31-2018 1006 Oct-31-2018 Salary flight_num 90000 100 85000 100 115000 100 25000 206 50000 206 45000 337 50000 337 75000 337 337 Nov-1-2018 1001 100 Nov-1-2018 1005 100 Nov-1-2018 1007 100 Nov-1-2018 1003 991 Nov-1-2018 1006 1007 991 Nov-1-2018 991 Nov-1-2018 1002 112 1004 Nov-1-2018 1008 Nov-1-2018 112 112



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *