CREATE TABLE campuses (campus VARCHAR(255), LOCATION VARCHAR(255), county VARCHAR(255))
Find the name of the campuses that is in Northridge, Los Angeles or in San Francisco, San Francisco.
    
SQL: SELECT campus FROM campuses WHERE LOCATION = "Northridge" AND county = "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION = "San Francisco" AND county = "San Francisco"