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