Explore a diverse range of topics and get expert answers on IDNLearn.com. Ask your questions and receive comprehensive and trustworthy answers from our experienced community of professionals.

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