Query

$6,$

$7,$

$8$

$(6)$ Show the number of students in each department per each class $($freshman$,$ sophomore, junior, and senuor$).$

$=>$ SELECT?, $?,$ COTNT $(?)$ AS N$\_$af$\_$Students

$$ GROUP BY$??$

$(7)$ List the FacultyID, CourseID, and Course Name with the highest evaluation for each faculty member

$=>$ SELECT?, $??,$ MAX$(?)$ AS MAX$\_$Evaluation

$.$ WHERE? $=?$

$$ GROUP BY$?,???$

$(8)$ Show DeptID and the number of sophomore students of each department that has more than $10$ sophomore studemts.

Make your result sorted in a descending order of DeptID.

$$ SELECT??, COUNT$(?)$ AS Num$\_$of Students

$$ GROUP BY$??$

$$ HAVING COUNT$[?]?$

$$ ORDER BY$??$