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_8 (deputy_prime_minister VARCHAR, term VARCHAR, left_office VARCHAR)
  ### Question:
  Which deputy prime minister left office in 2004 and was in the 7th legislature?
  ### Answer:
  SELECT deputy_prime_minister FROM table_name_8 WHERE term = "7th legislature" AND left_office = "2004"