human
Schema:
class (CLASS_CODE, CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
course (CRS_CODE, DEPT_CODE, CRS_DESCRIPTION, CRS_CREDIT)
department (DEPT_CODE, DEPT_NAME, SCHOOL_CODE, EMP_NUM, DEPT_ADDRESS, DEPT_EXTENSION)
employee (EMP_NUM, EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_JOBCODE, EMP_HIREDATE, EMP_DOB)
enroll (CLASS_CODE, STU_NUM, ENROLL_GRADE)
professor (EMP_NUM, DEPT_CODE, PROF_OFFICE, PROF_EXTENSION, PROF_HIGH_DEGREE)
student (STU_NUM, STU_LNAME, STU_FNAME, STU_INIT, STU_DOB, STU_HRS, STU_CLASS, STU_GPA, STU_TRANSFER, DEPT_CODE, STU_PHONE, PROF_NUM)
Please answer with SQL.
assistant
Sure, I understand.
human
Tell me class code for class room BUS311 ?
assistant
SELECT class_code FROM CLASS WHERE CLASS_ROOM = 'BUS311';
human
Tell me professor employee number for course code ACCT-211 ?
assistant
SELECT PROF_NUM FROM CLASS WHERE CRS_CODE = 'ACCT-211';
human
Tell me the class time for class section 3 ?
assistant
SELECT CLASS_TIME FROM CLASS WHERE CLASS_SECTION = 3;
human
Find the number of classes offered for all class rooms that held at least 2 classes ?
assistant
SELECT COUNT( * ) , class_room FROM CLASS GROUP BY class_room HAVING COUNT( * ) > = 2 ;