Your browser does not support JavaScript!

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 counts the number of ST_CLERK job_id? Rename the column as "Total no. of ST_CLERK".

  • SELECT COUNT(JOB_ID), AS TOTAL NO OF ST_CLERKFROM EMPLOYEESWHERE JOB_ID = =E2=80=98ST_CLERK=E2=80=99;
  • SELECT COUNT(JOB_ID), AS =E2=80=9CTOTAL NO OF ST_CLERK=E2=80=9DFROM EMPLOYEESWHERE JOB_ID != =E2=80=98ST_CLERK=E2=80=99;
  • SELECT COUNT * (JOB_ID), AS =E2=80=9CTOTAL NO OF ST_CLERK=E2=80=9DFROM EMPLOYEESWHERE JOB_ID = =E2=80=98ST_CLERK=E2=80=99;
  • SELECT COUNT(JOB_ID), AS =E2=80=9CTOTAL NO OF ST_CLERK=E2=80=9DFROM EMPLOYEESWHERE JOB_ID = =E2=80=98ST_CLERK=E2=80=99; Correct
Similar IT-6202 questions