#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)
Choose the letter of the correct answer based on the table EMPLOYEES as shown belowTable 10 EMPLOYEESWhat query should be used in order to display the lastname and salary of all employees whose department_id = 60 or job_id like =E2=80=98_T%' Format the salary to be 15 character long, left padded with =E2=80=98$' as special character Label the column Salary
Answer
SELECT LASTNAME, LPAD(SALARY,15,'$') AS SALARYFROM EMPLOYEESWHERE DEPARTMENT_ID = 60 OR JOB_ID LIKE '_T';