text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  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.
  ### Answer:
  SELECT campus FROM campuses WHERE LOCATION = "Northridge" AND county = "Los Angeles" UNION SELECT campus FROM campuses WHERE LOCATION = "San Francisco" AND county = "San Francisco"