Table: senad_members
Columns: administrative_panel
agricultural_panel
cultural_and_educational_panel
industrial_and_commercial_panel
labour_panel
national_university_of_ireland
university_of_dublin
nominated_by_the_taoiseach
total

Question: What is the average total 0 are nominated by the Taoiseach and the agricultural panel is greater than 5?
SQL: SELECT AVG("total") FROM senad_members WHERE "nominated_by_the_taoiseach" = 0 AND "agricultural_panel" > 5

Question: What is the total of the cultural and educational panel when the industrial and commercial panel is 0 and the agricultural panel is greater than 0?
SQL: SELECT SUM("cultural_and_educational_panel") FROM senad_members WHERE "industrial_and_commercial_panel" = 0 AND "agricultural_panel" > 0

Question: What is the total for the University of Dublin when 2 are nominated by Taoiseach and the industrial and commercial panel is greater than 0?
SQL: SELECT SUM("university_of_dublin") FROM senad_members WHERE "nominated_by_the_taoiseach" = 2 AND "industrial_and_commercial_panel" > 0

Question: What is the highest labour panel when the university of dublin is less than 2 and the agricultural panel is greater than 5?
SQL: SELECT MAX("labour_panel") FROM senad_members WHERE "university_of_dublin" < 2 AND "agricultural_panel" > 5

Question: What is the average for the university of dublin when the industrial and commercial panel is greater than 4 and the total of the national university of ireland is larger than 3?
SQL: SELECT AVG("university_of_dublin") FROM senad_members WHERE "industrial_and_commercial_panel" > 4 AND "national_university_of_ireland" > 3