How many HUC example codes have 1 level?
CREATE TABLE table_name_48 (example_code__huc_ VARCHAR, level VARCHAR)
SELECT COUNT(example_code__huc_) FROM table_name_48 WHERE level = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_48 (example_code__huc_ VARCHAR, level VARCHAR) Question: How many HUC example codes have 1 level? [/INST] SELECT COUNT(example_code__huc_) FROM table_name_48 WHERE level = 1 </s>