dept_id number(9))
you wang choose last_name and first_name that are not assigned department number.
select last_name,first_name from employee where dept_id is null;
a. create a out join
b. change the column in where cluse
c. change the operter in where cluse
d.add the second condition in the where cluse
which is the best answer?