Who attended Columbia law school and was appointed in 2004?
CREATE TABLE table_name_30 (
    name VARCHAR,
    law_school_attended VARCHAR,
    appointed VARCHAR
)
SELECT name FROM table_name_30 WHERE law_school_attended = "columbia law school" AND appointed = 2004
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: Who attended Columbia law school and was appointed in 2004? ### Input: CREATE TABLE table_name_30 (
    name VARCHAR,
    law_school_attended VARCHAR,
    appointed VARCHAR
) ### Response: SELECT name FROM table_name_30 WHERE law_school_attended = "columbia law school" AND appointed = 2004