What is City, when ASTC Member is No, when State is California, and when AAM Member is Yes?
CREATE TABLE table_42122 (
    "City" text,
    "State" text,
    "AAM Accredited" text,
    "AAM Member" text,
    "ASTC Member" text
)
SELECT "City" FROM table_42122 WHERE "ASTC Member" = 'no' AND "State" = 'california' AND "AAM Member" = 'yes'
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 ASTC Member is No, when State is California, and when AAM Member is Yes? ### Input: CREATE TABLE table_42122 (
    "City" text,
    "State" text,
    "AAM Accredited" text,
    "AAM Member" text,
    "ASTC Member" text
) ### Response: SELECT "City" FROM table_42122 WHERE "ASTC Member" = 'no' AND "State" = 'california' AND "AAM Member" = 'yes'