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
what is the school code of emp num 114
assistant
SELECT SCHOOL_CODE FROM DEPARTMENT WHERE EMP_NUM = 114;
human
what is the school code of fine arts
assistant
SELECT SCHOOL_CODE FROM DEPARTMENT WHERE DEPT_NAME = 'Fine Arts';
human
what is the dept address of accounting
assistant
SELECT DEPT_ADDRESS FROM DEPARTMENT WHERE DEPT_NAME = 'Accounting';
human
what is the prof extension of hist
assistant
SELECT PROF_EXTENSION FROM PROFESSOR WHERE DEPT_CODE = "HIST" ;