CREATE TABLE table_42124 ("City" CLOB, "State" CLOB, "AAM Accredited" CLOB, "AAM Member" CLOB, "ASTC Member" CLOB)

What is City, when State is California, when AAM Accredited is No, when ASTC Member is Yes, and when AAM Member is No?
SELECT "City" FROM table_42124 WHERE "State" = 'california' AND "AAM Accredited" = 'no' AND "ASTC Member" = 'yes' AND "AAM Member" = 'no'
SELECT "City" FROM "table_42124" WHERE "AAM Accredited" = 'no' AND "AAM Member" = 'no' AND "ASTC Member" = 'yes' AND "State" = 'california'