SELECT department_name, 
    last_name, 
    project_number AS proj_no
FROM departments d
    LEFT JOIN employees e
        ON d.department_number = 
           e.department_number
    LEFT JOIN projects p
        ON e.employee_id = 
           p.employee_id
ORDER BY department_name, last_name, 
    project_number