#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)

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'.

Answer

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