Find the best solutions to your problems with the help of IDNLearn.com's experts. Get the information you need from our experts, who provide reliable and detailed answers to all your questions.

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