What is City, when State is California, when AAM Accredited is No, when ASTC Member is Yes, and when AAM Member is No?
CREATE TABLE "see_also" (
  "city" text,
  "state" text,
  "aam_accredited" text,
  "aam_member" text,
  "astc_member" text
);
SELECT "city" FROM "see_also" WHERE "state"='california' AND "aam_accredited"='no' AND "astc_member"='yes' AND "aam_member"='no';