Which of the following is the correct example of creating a view where LASTNAME ends with letter S rename LASTNAME to SURNAME?

• CREATE VIEW WORKERS (EMPLOYEE_ID, SURNAME, FIRSTNAME)AS (EMPLOYEE_ID, LASTNAME, FIRSTNAMEFROM EMPLOYEES WHERE SALARY LASTNAME LIKE '%S'); Correct