Employees With Department Name

Problem

Write a query that returns each employee's first_name and last_name along with the name of their department (aliased as department_name), by joining employees to departments. Order the results by department_name, then by last_name.

Try It

Hint

Solution