examine the structure of the EMPLOYEES table.
There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123 Which query provides the correct output?
A. Option A
B. Option B
C. Option C
D. Option D
D is true
B and C are not the exact same, the select statements are different. B is correct
furthermore, the question says where employee id = 123, if you changed “m.employee_id = 123” like mr anonymous suggested, you wouldnt even be querying the data the question is asking for.
None of these are correct. B & C are the exact same.
If you change B to say “WHERE m.employee_id = 123” you would get the correct result.
D
D is the right