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 lowest salary rename as "LOWEST SALARY", maximum salary rename as "HIGHEST SALARY" and department_id concatenated to job_id?

  • SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEESGROUP BY DEPARTMENT_ID;
  • SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEESGROUP BY JOB_ID;
  • SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEESGROUP BY JOB_ID,DEPARTMENT_ID; Correct
  • SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEES;
Similar IT-6202 questions