Table: senate_members
Columns: administrative_panel
agricultural_panel
cultural_and_educational_panel
industrial_and_commercial_panel
labour_panel
national_university_of_ireland
nominated_by_the_taoiseach
total

Question: What is the average nominated of the composition nominated by Taioseach with an Industrial and Commercial panel less than 9, an administrative panel greater than 0, a cultural and educational panel greater than 2, and a total less than 29?
SQL: SELECT AVG("nominated_by_the_taoiseach") FROM senate_members WHERE "industrial_and_commercial_panel" < 9 AND "administrative_panel" > 0 AND "cultural_and_educational_panel" > 2 AND "total" < 29

Question: What is the average administrative panel of the composition nominated by Taoiseach 0 times with a total less than 4?
SQL: SELECT AVG("administrative_panel") FROM senate_members WHERE "nominated_by_the_taoiseach" = 0 AND "total" < 4

Question: What is the highest number of nominations by Taoiseach of the composition with an administrative panel greater than 0 and an industrial and commercial panel less than 1?
SQL: SELECT MAX("nominated_by_the_taoiseach") FROM senate_members WHERE "administrative_panel" > 0 AND "industrial_and_commercial_panel" < 1

Question: What is the average agricultural panel of the composition with a labour panel less than 6, more than 0 nominations by Taoiseach, and a total less than 4?
SQL: SELECT AVG("agricultural_panel") FROM senate_members WHERE "labour_panel" < 6 AND "nominated_by_the_taoiseach" > 0 AND "total" < 4

Question: What is the total number of agriculatural panels of the composition with more than 3 National Universities of Ireland?
SQL: SELECT COUNT("agricultural_panel") FROM senate_members WHERE "national_university_of_ireland" > 3