I want to know the total number of national university of ireland with agricultural panel of 0 and labour panel more than 0
CREATE TABLE table_name_34 (
    national_university_of_ireland VARCHAR,
    agricultural_panel VARCHAR,
    labour_panel VARCHAR
)
SELECT COUNT(national_university_of_ireland) FROM table_name_34 WHERE agricultural_panel = 0 AND labour_panel > 0
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: I want to know the total number of national university of ireland with agricultural panel of 0 and labour panel more than 0 ### Input: CREATE TABLE table_name_34 (
    national_university_of_ireland VARCHAR,
    agricultural_panel VARCHAR,
    labour_panel VARCHAR
) ### Response: SELECT COUNT(national_university_of_ireland) FROM table_name_34 WHERE agricultural_panel = 0 AND labour_panel > 0