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
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_34 (national_university_of_ireland VARCHAR, agricultural_panel VARCHAR, labour_panel VARCHAR) Question: I want to know the total number of national university of ireland with agricultural panel of 0 and labour panel more than 0 [/INST] SELECT COUNT(national_university_of_ireland) FROM table_name_34 WHERE agricultural_panel = 0 AND labour_panel > 0 </s>