Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.<br /> You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）<img src="https://nimg.ppkao.com/2018-08/zhangxu/2018080111484519157.jpg?sign=f452fbba9ea501735c85da43e5a7c644&t=62d33005" />

A、SELECT last_name, department_name FROM employees NATURAL JOIN departments;

B、SELECT last_name, department_name FROM employees JOIN departments ;

C、SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);

D、SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id); 

E、SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);

F、SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);