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 table_name_30 (
    city VARCHAR,
    aam_member VARCHAR,
    astc_member VARCHAR,
    state VARCHAR,
    aam_accredited VARCHAR
)
SELECT city FROM table_name_30 WHERE state = "california" AND aam_accredited = "no" AND astc_member = "yes" AND aam_member = "no"
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is City, when State is California, when AAM Accredited is No, when ASTC Member is Yes, and when AAM Member is No? ### Input: CREATE TABLE table_name_30 (
    city VARCHAR,
    aam_member VARCHAR,
    astc_member VARCHAR,
    state VARCHAR,
    aam_accredited VARCHAR
) ### Response: SELECT city FROM table_name_30 WHERE state = "california" AND aam_accredited = "no" AND astc_member = "yes" AND aam_member = "no"