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: I want to know the total number of national university of ireland with agricultural panel of 0 and labour panel more than 0
SQL: SELECT COUNT("national_university_of_ireland") FROM senate_members WHERE "agricultural_panel" = 0 AND "labour_panel" > 0

Question: Tell me the total number of administrative panel with labour panel more than 2, nominated by taoiseach more than 6 and total of 28
SQL: SELECT COUNT("administrative_panel") FROM senate_members WHERE "labour_panel" > 2 AND "total" = 28 AND "nominated_by_the_taoiseach" > 6