-- Database schema
| CLASS : CLASS_CODE [ TEXT ] primary_key , CRS_CODE [ TEXT ] CLASS.CRS_CODE = COURSE.CRS_CODE , CLASS_SECTION [ TEXT ] , CLASS_TIME [ TEXT ] , CLASS_ROOM [ TEXT ] , PROF_NUM [ INT ] CLASS.PROF_NUM = EMPLOYEE.EMP_NUM | COURSE : CRS_CODE [ TEXT ] primary_key , DEPT_CODE [ TEXT ] COURSE.DEPT_CODE = DEPARTMENT.DEPT_CODE , CRS_DESCRIPTION [ TEXT ] , CRS_CREDIT [ INT ] | DEPARTMENT : DEPT_CODE [ TEXT ] primary_key , DEPT_NAME [ TEXT ] , SCHOOL_CODE [ TEXT ] , EMP_NUM [ INT ] DEPARTMENT.EMP_NUM = EMPLOYEE.EMP_NUM , DEPT_ADDRESS [ TEXT ] , DEPT_EXTENSION [ TEXT ] | EMPLOYEE : EMP_NUM [ INT ] primary_key , EMP_LNAME [ TEXT ] , EMP_FNAME [ TEXT ] , EMP_INITIAL [ TEXT ] , EMP_JOBCODE [ TEXT ] , EMP_HIREDATE [ TEXT ] , EMP_DOB [ TEXT ] | ENROLL : CLASS_CODE [ TEXT ] ENROLL.CLASS_CODE = CLASS.CLASS_CODE , STU_NUM [ INT ] ENROLL.STU_NUM = STUDENT.STU_NUM , ENROLL_GRADE [ TEXT ] | PROFESSOR : EMP_NUM [ INT ] PROFESSOR.EMP_NUM = EMPLOYEE.EMP_NUM , DEPT_CODE [ TEXT ] PROFESSOR.DEPT_CODE = DEPARTMENT.DEPT_CODE , PROF_OFFICE [ TEXT ] , PROF_EXTENSION [ TEXT ] , PROF_HIGH_DEGREE [ TEXT ] | STUDENT : STU_NUM [ INT ] primary_key , STU_LNAME [ TEXT ] , STU_FNAME [ TEXT ] , STU_INIT [ TEXT ] , STU_DOB [ TEXT ] , STU_HRS [ INT ] , STU_CLASS [ TEXT ] , STU_GPA [ INT ] , STU_TRANSFER [ INT ] , DEPT_CODE [ TEXT ] STUDENT.DEPT_CODE = DEPARTMENT.DEPT_CODE , STU_PHONE [ TEXT ] , PROF_NUM [ INT ] |
-- -- how many schools exist in total?

SELECT count(DISTINCT school_code) FROM department;