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 display the Minimum firstname concatenated to lastname? Look for the maximum salary that is less than 10000 per department_id.
SELECT MIN(FIRSTNAME,LASTNAME)FROM EMPLOYEESGROUP BY DEPARTMENT_IDHAVING MAX(SALARY)<10000;
SELECT MIN(FIRSTNAME||LASTNAME)FROM EMPLOYEESGROUP BY DEPARTMENT_IDHAVING MAX(SALARY)<10000;Correct
SELECT MIN(FIRSTNAME||LASTNAME)FROM EMPLOYEESGROUP BY DEPARTMENT_IDHAVING MAX(SALARY);
SELECT MIN(FIRSTNAME||LASTNAME)FROM EMPLOYEESHAVING MAX(SALARY)<10000GROUP BY DEPARTMENT_ID;