How_to_retrieve_data_from_two_or_more_tables/exec_5C73.sql

use ex;


SELECT department_name, last_name, project_number
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