Equi-Join Between EMPLOYEES and DEPARTMENTS

Question 1

You need to create a report displaying employee last names, department names, and locations, using the structure of the given tables: ``` EMPLOYEES: EMPLOYEE_ID NUMBER, DEPARTMENT_ID NUMBER, MANAGER_ID NUMBER, LAST_NAME VARCHAR2(25) DEPARTMENTS: DEPARTMENT_ID NUMBER, MANAGER_ID NUMBER, DEPARTMENT_NAME VARCHAR2(35), LOCATION_ID NUMBER ``` Which query should you use to create an equi-join from the s