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 report that display the smallest (minimum) Surname.. and apply the ff. functions:Get the average salary; Group the data per job_id; Get only job_id with a keyword "REP"; and Apply having clause, which the max salary per job_id is greater than 5000.

• SELECT CONCAT(DEPARTMENT_ID,JOB_ID),MIN(SALARY), MAX(SALARY)FROM EMPLOYEESGROUP BY JOB_ID;
• SELECT MIN(LASTNAME), AVG(SALARY)FROM EMPLOYEESWHERE JOB_ID NOT LIKE =E2=80=98%REP%=E2=80=99GROUP BY JOB_IDHAVING MAX(SALARY)>500;
• SELECT MIN(LASTNAME), AVG(SALARY)FROM EMPLOYEESGROUP BY JOB_IDWHERE JOB_ID LIKE =E2=80=98%REP%=E2=80=99HAVING MAX(SALARY)>500;
• SELECT MIN(LASTNAME), AVG(SALARY)FROM EMPLOYEESWHERE JOB_ID LIKE =E2=80=98%REP%=E2=80=99GROUP BY JOB_IDHAVING MAX(SALARY)>500; Correct