Create a view employee_directory with emp_id, full_name (first + space + last) and dept_name. Employees without a department should still appear (with an empty department).
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.