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 that display distinct job_id and the the total number per distinct (unique) job_id.
SELECT DISTICT(JOB_ID), COUNT*(JOB_ID) AS =E2=80=9CTOTAL NUMBER OF JOB_ID=E2=80=9DFROM EMPLOYEESGROUP BY JOB_ID;
SELECT DISTICT(JOB_ID), COUNT(JOB_ID) AS =E2=80=9CTOTAL NUMBER OF JOB_ID=E2=80=9DFROM EMPLOYEES;
SELECT DISTICT(JOB_ID), COUNT(JOB_ID) AS =E2=80=9CTOTAL NUMBER OF JOB_ID=E2=80=9DFROM EMPLOYEESGROUP BY JOB_ID;Correct
SELECT DISTICT((JOB_ID), COUNT(JOB_ID)) AS =E2=80=9CTOTAL NUMBER OF JOB_ID=E2=80=9DFROM EMPLOYEESGROUP BY JOB_ID;