How many have are model 2.4 awd?
CREATE TABLE table_1147705_1 (engine_type VARCHAR, model VARCHAR)
SELECT COUNT(engine_type) FROM table_1147705_1 WHERE model = "2.4 AWD"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1147705_1 (engine_type VARCHAR, model VARCHAR) Question: How many have are model 2.4 awd? [/INST] SELECT COUNT(engine_type) FROM table_1147705_1 WHERE model = "2.4 AWD" </s>