Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name of all employees who's managed by 'KING'? Select one:...


Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id)<br>Which of the following queries will display the last name of all employees who's managed by 'KING'?<br>Select one:<br>a.SELECT e.last_name FROM employees e, employees m WHERE upper(last_name) = 'KING'<br>b.SELECT e.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id and upper(m.last_name) = 'KING'<br>c.none of the above<br>d.SELECT m.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id<br>

Extracted text: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name of all employees who's managed by 'KING'? Select one: a.SELECT e.last_name FROM employees e, employees m WHERE upper(last_name) = 'KING' b.SELECT e.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id and upper(m.last_name) = 'KING' c.none of the above d.SELECT m.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here