How many customers have an active value of 1?
CREATE TABLE customer (active VARCHAR)
SELECT COUNT(*) FROM customer WHERE active = '1'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE customer (active VARCHAR) Question: How many customers have an active value of 1? [/INST] SELECT COUNT(*) FROM customer WHERE active = '1' </s>