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

Answer

SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEESGROUP BY JOB_ID,DEPARTMENT_ID;