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

Find the name of the campuses that is in Northridge, Los Angeles or in San Francisco, San Francisco.
SELECT campus FROM campuses WHERE location = "Northridge" AND county = "Los Angeles" UNION SELECT campus FROM campuses WHERE location = "San Francisco" AND county = "San Francisco"
SELECT "campus" FROM "campuses" WHERE "Los Angeles" = "county" AND "Northridge" = "location" UNION SELECT "campus" FROM "campuses" WHERE "San Francisco" = "county" AND "San Francisco" = "location"