Table: election_results_rohrheim
Columns: parties_and_voter_communities
2006
seats_2006
2001
seats_2001

Question: What is the %2006 that has fewer seats than 23 in Seats 2001, more seats than 4 in 2006 Seats, and a % in 2001 of 25.4?
SQL: SELECT "2006" FROM election_results_rohrheim WHERE "seats_2001" < 23 AND "seats_2006" > 4 AND "2001" = 25.4

Question: When the %2001 is more than 61.4, and the %2006 fewer than 54.1, how many Seats in 2001 were there?
SQL: SELECT SUM("seats_2001") FROM election_results_rohrheim WHERE "2001" > 61.4 AND "2006" < 54.1

Question: What is the highest number of Seats 2006 held by the Christian Democratic Union of Germany Party/Voter Community, with a %2006 higher than 24.6?
SQL: SELECT MAX("seats_2006") FROM election_results_rohrheim WHERE "parties_and_voter_communities" = 'christian democratic union of germany' AND "2006" > 24.6

Question: What is the highest number of Seats 2006 held by the communities of Bürger Für Groß-Rohrheim Party/Voter Community, with a %2006 less than 21.3?
SQL: SELECT MAX("seats_2006") FROM election_results_rohrheim WHERE "parties_and_voter_communities" = 'bürger für groß-rohrheim' AND "2006" < 21.3

Question: What is the %2006 when the %2001 was more than 62.5?
SQL: SELECT AVG("2006") FROM election_results_rohrheim WHERE "2001" > 62.5