CREATE TABLE degrees (year NUMBER, campus NUMBER, degrees NUMBER)
CREATE TABLE faculty (campus NUMBER, year NUMBER, faculty NUMBER)
CREATE TABLE enrollments (campus NUMBER, year NUMBER, totalenrollment_ay NUMBER, fte_ay NUMBER)
CREATE TABLE discipline_enrollments (campus NUMBER, discipline NUMBER, year NUMBER, undergraduate NUMBER, graduate NUMBER)
CREATE TABLE campuses (id NUMBER, campus CLOB, location CLOB, county CLOB, year NUMBER)
CREATE TABLE csu_fees (campus NUMBER, year NUMBER, campusfee NUMBER)

How many campuses exist are in the county of LA?
SELECT COUNT(*) FROM campuses WHERE county = "Los Angeles"
SELECT COUNT(*) FROM "campuses" WHERE "Los Angeles" = "county"