Which deputy prime minister left office in 2004 and was in the 7th legislature?
CREATE TABLE "list_of_deputy_prime_ministers_of_spain" (
  "deputy_prime_minister" text,
  "took_office" real,
  "left_office" text,
  "prime_minister" text,
  "term" text,
  "party" text
);
SELECT "deputy_prime_minister" FROM "list_of_deputy_prime_ministers_of_spain" WHERE "term"='7th legislature' AND "left_office"='2004';