WHAT IS THE SEATS IN Hamburgische Bürgerschaft THAT HAS GREEN POLITICS?
CREATE TABLE "political_parties" (
  "name_english" text,
  "name_german" text,
  "abbr" text,
  "ideology" text,
  "position" text,
  "votes_2011" text,
  "seats_in_hamburgische_b_rgerschaft" real
);
SELECT "seats_in_hamburgische_b_rgerschaft" FROM "political_parties" WHERE "ideology"='green politics';