Consider the table given below:
TABLE: STUDENT
$$
\begin{array}{|l|l|l|}
\hline \text { ADM } & \text { NAME } & \text { CLASS } \\
\hline 1 & \text { Anshuman } & \text { 12A } \\
\hline 2 & \text { Arun Lal } & \text { 12C } \\
\hline 3 & \text { Sachin } & \text { 12A } \\
\hline 4 & \text { Kapil } & \text { 12B } \\
\hline 5 & \text { Sunil } & 12 \mathrm{~A} \\
\hline 6 & \text { Virat } & 12 \mathrm{C} \\
\hline
\end{array}
$$
Based on the above table, which command will give the following result:
$$
\begin{array}{|l|l|}
\hline \text { CLASS } & \text { No. of students } \\
\hline \text { 12A } & 3 \\
\hline 12 \mathrm{C} & 2 \\
\hline
\end{array}
$$
(A) Select CLASS, Count (*) From STUDENT Group by CLASS;
(B) Select CLASS, Count(*) 'No of students'
From STUDENT
GROUP by CLASS;
(C) SELECT CLASS, COUNT (No of students)
FROM STUDENT
Group By CLASS
Having count (*)>1;
(D) SELECT CLASS, COUNT (*) 'No of students'
EROM STUDENT
Group By CLASS
Having count (*) $>1$;