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 cname for classes which student with studentID 20343 enrolled ordered by cname Ascendingly.

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.