Exhibit Examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees' last names, along with their manager's last names and their department names. Which query would…

Question

Exhibit

Options

• ASELECT last_name, manager_id, department_name FROM employees e
• BSELECT e.last_name, m.last_name, department_name FROM employees e
• CSELECT e.last_name, m.last_name, department_name FROM employees e
• DSELECT e.last_name, m.last_name, department_name
• ESELECT e.last_name, m.last_name, department_name
• FSELECT last_name, manager_id, department_name

• A
  7% (2)
• B
  85% (23)
• C
  4% (1)
• F
  4% (1)

No community discussion yet for this question.