How_to_retrieve_data_from_a_single_table/exec_5C75.sql

USE EX;

SELECT department_name, last_name, project_number
FROM departments
JOIN employees USING (department_number)
LEFT JOIN projects USING (employee_id)
ORDER BY department_nameuse ex;