How_to_retrieve_data_from_a_single_table/exer_5C15.sql

USE ex;
SELECT department_name, last_name, project_number 
FROM departments d 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 ASC;