Which county has a membership of 1, a franchise type of corporation and a borough of Ennis?
CREATE TABLE table_24329520_8 (county VARCHAR, borough VARCHAR, members VARCHAR, franchise_type VARCHAR)
SELECT county FROM table_24329520_8 WHERE members = 1 AND franchise_type = "Corporation" AND borough = "Ennis"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24329520_8 (county VARCHAR, borough VARCHAR, members VARCHAR, franchise_type VARCHAR) Question: Which county has a membership of 1, a franchise type of corporation and a borough of Ennis? [/INST] SELECT county FROM table_24329520_8 WHERE members = 1 AND franchise_type = "Corporation" AND borough = "Ennis" </s>