text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_30 (name VARCHAR, law_school_attended VARCHAR, appointed VARCHAR)
  ### Question:
  Who attended Columbia law school and was appointed in 2004?
  ### Answer:
  SELECT name FROM table_name_30 WHERE law_school_attended = "columbia law school" AND appointed = 2004