Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order todisplay the firstname in capitalized format rename the column as pangalan whose job_id is equal to =E2=80=98SA_REP'.

• SELECT UPPER(FIRSTNAME) PANGALANFROM EMPLOYEESWHERE JOB_ID = 'SA_REP';
• SELECT FIRSTNAME AS PANGALANFROM EMPLOYEESWHERE JOB_ID = 'SA_REP';
• SELECT UPPER(FIRSTNAME) AS PANGALANFROM EMPLOYEESWHERE JOB_ID IS 'SA_REP';
• SELECT UPPER(FIRSTNAME) AS PANGALANFROM EMPLOYEESWHERE JOB_ID = 'SA_REP'; Correct