SQL JOINS on HR Database: Display the department name and the full name of the manager
SQL JOINS on HR Database: Exercise-18 with Solution
18. Write a query in SQL to display department name and the full name (first and last name) of the manager.
Sample table: departments
Sample table: employees
SELECT department_name, first_name || ' ' || last_name AS name_of_manager FROM departments D JOIN employees E ON (D.manager_id=E.employee_id);
department_name name_of_manager Executive Steven King IT Alexander Hunold Finance Nancy Greenberg Purchasing Den Raphaely Shipping Adam Fripp Sales John Russell Administration Jennifer Whalen Marketing Michael Hartstein Human Resources Susan Mavris Public Relations Hermann Baer Accounting Shelley Higgins
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?