-- Database schema
| Campuses : Id [ INT ] primary_key , Campus [ TEXT ] , Location [ TEXT ] , County [ TEXT ] , Year [ INT ] | csu_fees : Campus [ INT ] primary_key csu_fees.Campus = Campuses.Id , Year [ INT ] , CampusFee [ INT ] | degrees : Year [ INT ] primary_key , Campus [ INT ] degrees.Campus = Campuses.Id , Degrees [ INT ] | discipline_enrollments : Campus [ INT ] primary_key discipline_enrollments.Campus = Campuses.Id , Discipline [ INT ] , Year [ INT ] , Undergraduate [ INT ] , Graduate [ INT ] | enrollments : Campus [ INT ] primary_key enrollments.Campus = Campuses.Id , Year [ INT ] , TotalEnrollment_AY [ INT ] , FTE_AY [ INT ] | faculty : Campus [ INT ] faculty.Campus = Campuses.Id , Year [ INT ] , Faculty [ INT ] |
-- -- What campuses opened before 1800?

SELECT campus FROM campuses WHERE YEAR  <  1800;