what is the amount where the area is new brunswick
CREATE TABLE table_29012710_1 (production__hectolitres_ VARCHAR, province VARCHAR)
SELECT production__hectolitres_ FROM table_29012710_1 WHERE province = "New Brunswick"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_29012710_1 (production__hectolitres_ VARCHAR, province VARCHAR) Question: what is the amount where the area is new brunswick [/INST] SELECT production__hectolitres_ FROM table_29012710_1 WHERE province = "New Brunswick" </s>