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
How many different courses are there?
assistant
SELECT COUNT( distinct CRS_CODE ) FROM course;
human
How many departments are there?
assistant
SELECT COUNT( DEPT_CODE ) FROM department;
human
What is the course code for the class named Statistics? | Do you mean the course code for the course whose description is Statistics? | yes.
assistant
SELECT CRS_CODE FROM course WHERE CRS_DESCRIPTION = 'Statistics';
human
Can you show me a list of all the course descriptions?
assistant
SELECT CRS_DESCRIPTION FROM course;
human
Can you tell me the course code for the class with the Intro. to Statistics description?
assistant
SELECT CRS_CODE FROM course WHERE CRS_DESCRIPTION = 'Intro. to Statistics';
human
What is the name of the department that course is in? | Do you mean the name of the department which the course named 'Intro. to Statistics' is in? | yes.
assistant
SELECT T2.dept_name FROM course AS T1 JOIN department AS T2 ON T1.dept_code = T2.dept_code WHERE T1.crs_description = "Intro. to Statistics" ;