CREATE TABLE table_name_34 (national_university_of_ireland VARCHAR, agricultural_panel VARCHAR, labour_panel VARCHAR)
I want to know the total number of national university of ireland with agricultural panel of 0 and labour panel more than 0
SELECT COUNT(national_university_of_ireland) FROM table_name_34 WHERE agricultural_panel = 0 AND labour_panel > 0