Find the name of the campuses that is in Northridge, Los Angeles or in San Francisco, San Francisco.
CREATE TABLE campuses (campus VARCHAR, LOCATION VARCHAR, county VARCHAR)
[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" [/SQL]