Table: chief_judge_jonathan_lippman
Columns: name
appointed
term_expiration
appointing_governor
law_school_attended

Question: Who attended Columbia law school and was appointed in 2004?
SQL: SELECT "name" FROM chief_judge_jonathan_lippman WHERE "law_school_attended" = 'columbia law school' AND "appointed" = 2004

Question: Which Term expiration has an Appointing Governor of george pataki, republican, and an Appointed larger than 2004?
SQL: SELECT SUM("term_expiration") FROM chief_judge_jonathan_lippman WHERE "appointing_governor" = 'george pataki, republican' AND "appointed" > 2004

Question: Which law school did judge sheila abdus-salaam attend, who was appointed in 2004?
SQL: SELECT "law_school_attended" FROM chief_judge_jonathan_lippman WHERE "appointed" > 2004 AND "name" = 'judge sheila abdus-salaam'