STUDENT
Observe the Table STUDENT:
STUDENT This Table Will Be Used for the Following Questions Citing

Essay

STUDENT
Observe the table STUDENT:
STUDENT
$$\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Cass } } \\\hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\D 444 & 444 - 44-4444 & \text { Parker } & \text { Sophomore } \\D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore }\end{array}$$

This table will be used for the following questions citing table STUDENT.
-Write an SQL query on the table STUDENT that for each class lists the class and the number of students in the class.