Review the following SQL, and choose the most appropriate option.

  1. The statement will show the number of jobs in each department

  2. The statement will show the number of employees in each department.

  3. The statement will generate an error.

  4. The statement will work if the GROUP BY clause is removed.


Correct Option: C

Find more quizzes: