CREATE TABLE campuses (campus VARCHAR, LOCATION VARCHAR, county VARCHAR)
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"