To create a report displaying employee last names, department names, and locations. Which query should you use to create an equi- join?
Answer options
A
department_id =
B
department_id; SELECT
C
last_name
D
department_name
E
location_id FROM employees e, departments d WHERE manager_id =manager_id; SELECT
F
last_name
G
department_name
H
location_id FROM employees e, departments d WHERE
I
department_id =
J
department_id;
K
last_name
L
depa5rtme2nt_na2me, 4
M
loca8tion_id FROM employees e, departments d WHERE
N
department_id =
O
department_id;
Correct answer: department_id =
Explanation
Refer to Database Management — 07 Joins & Subquery study materials.