SOLVE THE QUERY USING THE GIVEN RELATIONSHIP TABLE

$(4)$ Show DeptID and the number of students who received a grade of $4\mathrm{.}0$ during fall $2000$ in each department.

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

FROM $????$

WHERE $?=?$

AND? $=?$

AND $?=?$

AND $?=?$

AND $?=?$

GROUP BY$?$