#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 EMPLOYEESWhich of the following is the correct query that displays the MINIMUM salary of employees per job_id? Note job_id should be in lowercase.
Answer
SELECT MIN(SALARY) AS =E2=80=9CLOWEST SALARY=E2=80=9D, LOWER(JOB_ID)FROM EMPLOYEESGROUP BY JOB_ID;