You are looking for executive information using a subquery. What will the following sql statement display?
a. select department_id, last_name, job_id
b. from employees where department_id in
c. (select department_id from
d. departments where department_name = '