How_to_retrieve_data_from_two_or_more_tables/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