For each classroom, display its LOCID and its average occupancy rate in ascending order of average occupancy rate. (For example, based on the current contents of the database, average occupancy rate for classroom with LOCID being 1 is 0.5667). (Remember that faculty office rooms are not classrooms). Note: How to compute the average occupancy rate of classroom with LOCID=1? Answer: The capacity of that classroom is 150. There are 2 sections taught in that classroom: CSECID=1 with CURRENRL=135; CSECID=11 with CURRENRL=35. So, Average occupancy rate is [(135/150) + (35/150)]/2 = 0.566

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