Your browser does not support JavaScript!

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. 

  • SELECT MIN(SALARY) AS LOWEST SALARY, LOWER(JOB_ID)FROM EMPLOYEES;
  • SELECT MIN(SALARY) AS =E2=80=9CLOWEST SALARY=E2=80=9D, LOWER(JOB_ID)FROM EMPLOYEESGROUP BY JOB_ID; Correct
  • SELECT MIN(SALARY) AS =E2=80=9CLOWEST SALARY=E2=80=9D, LOWER(JOB_ID)FROM EMPLOYEES;
  • SELECT MIN(SALARY) AS LOWEST SALARY, LOWER(JOB_ID)FROM EMPLOYEESGROUP BY JOB_ID;
Similar IT-6202 questions