How_to_retrieve_data_from_a_single_table/exec_5C72.sql

use ex;

SELECT department_name, e.department_number, last_name
FROM departments d RIGHT JOIN employees e
	ON d.department_number = e.department_number
ORDER BY department_name