CREATE TABLE table_name_30 (city VARCHAR(255), aam_member VARCHAR(255), astc_member VARCHAR(255), state VARCHAR(255), aam_accredited VARCHAR(255))
What is City, when State is California, when AAM Accredited is No, when ASTC Member is Yes, and when AAM Member is No?
    
SQL: SELECT city FROM table_name_30 WHERE state = "california" AND aam_accredited = "no" AND astc_member = "yes" AND aam_member = "no"