Problem Statement

Show every department alongside each of its employees. Departments with zero employees still appear (with NULL employee fields). Return department_id, department_name, location, employee_id, first_name, last_name, salary — ordered by department_id, salary DESC NULLS LAST, employee_id.

Relevant Tables