Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?
selection, projection, join
selection, intersection, join
intersection, projection, join
difference, projection, product
difference, projection, join
Selection, projection and join capabilities of a SELECT statement are performed in this view.