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 student sname for students who is enrolled in class which has classNum 25 ordered by sname 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 students in each department.

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 classNum, number of student in each class has more than 24 students attend in room C003.