Database: csu_1
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"