QUESTION $2$

STUDENT

Observe the table STUDENT:

$\backslash$table$[[$StudentID$,$SSN$,$Name,Class$],[$D$111,111-11-1111,$Connor,Freshman$],[$D$222,222-22-2222,$Trevor,Freshman$],[$D$333,333-33-3333,$Connor,Sophomore$],[$D$444,444-44-4444,$Parker,Sophomore$],[$D$555,555-55-5555,$Connor,Sophomore$]]$

What will be the result of the following query on table STUDENT?

SELECT COUNT$(*)$

FROM student

GROUP BY class

HAVING COUNT ${(}^{**})<mn\; id="EditorElement\_15075740">3</mn>$;

A$.$ Number $5$

B$.$ Number $2$

C$.$ Numbers $2$ and $3$

D$.$ Numbers $1$ and $1$