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 = '