How_to_retrieve_data_from_two_or_more_tables/exer_5C14.sql

USE ex;
SELECT department_name, d.department_name, last_name 
FROM departments d LEFT JOIN employees e 
     ON d.department_number = e.department_number
ORDER BY department_name ASC;