Display the LOCID and CAPACITY and overall average capacity for all classrooms that have capacities that are higher than the overall average capacity. (Remember that faculty office rooms are not classrooms)

For each faculty rank, display the FRANKID, and the number of sections taught by faculty members with that rank, and the number of faculty members with that rank.

For each pair of faculty with the same rank, display their full names (FFNAME and FLNAME) and FRANKID.

Pair of faculty=Faculty with same ranks.

For each pair of faculty members with the same rank, display their full names (FFNAME and FLNAME), FRANKID and the number of sections each faculty member teaches.

For each student, display the SID and his/her GPA.

STUDENT ENROLLMENT COURSE SECTION COURSE CSECID SLNAME CSECID GRADE CALLID CNAME CCREDIT SECNUM SPHONE MAXENRL FACULTY CURRENRL TERM FID TERMID TDESC STATUS LOCATION 1LOCID FRANK FACULTYIMAGE FRANKID FRANKDESC BLDG CODE ROOM CAPACITY STUDENT ENROLLMENT COURSE SECTION COURSE CSECID SLNAME CSECID GRADE CALLID CNAME CCREDIT SECNUM SPHONE MAXENRL FACULTY CURRENRL TERM FID TERMID TDESC STATUS LOCATION 1LOCID FRANK FACULTYIMAGE FRANKID FRANKDESC BLDG CODE ROOM CAPACITY