Table schema:
CREATE TABLE campuses (campus VARCHAR, LOCATION VARCHAR, county VARCHAR)

Question: 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"