#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)
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".
Answer
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;