Table: mengerskirchen_elections
Columns: parties_and_voter_communities
2006
seats_2006
2001
seats_2001

Question: When seats for 2001 is greater than 15 and % 2001 is greater than 100, what is the % 2006?
SQL: SELECT AVG("2006") FROM mengerskirchen_elections WHERE "seats_2001" > 15 AND "2001" > 100

Question: What is the sum of % for 2001 if 2001 seats equals 7?
SQL: SELECT COUNT("2001") FROM mengerskirchen_elections WHERE "seats_2001" = 7

Question: If 2006 is 13% and 2001 is greater than 12.1%, what is the greatest number of seats for 2001?
SQL: SELECT MAX("seats_2001") FROM mengerskirchen_elections WHERE "2006" = 13 AND "2001" > 12.1