Consider the following relational schema, where the primary keys are underlined and foreign keys are marked with #:

Student(studentID, sname, major, level, #deptid)

Class(classNum, cname, Time, room, #teacherID)

Enrolled(#studentID, #classNum)

Teacher(teacherID, fname, #deptid)

Write the SQL Statement for the following query:

Retrieve deptid, number of teacher in each department.