Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order toget theSUBSTR  function that returns the job_id = =E2=80=98REP'.

• SELECT JOB_ID FROM EMPLOYEESWHERE JOB_ID LIKE =E2=80=98%REP%=E2=80=99;
• SELECT JOB_ID FROM EMPLOYEESWHERE SUBSTR(JOB_ID,4)='%REP%';
• SELECT JOB_ID FROM EMPLOYEESWHERE SUBSTR(JOB_ID,4)='REP'; Correct
• SELECT JOB_ID FROM EMPLOYEESWHERE SUBSTR='REP';