How many ranks have an industry of health care?
CREATE TABLE table_name_42 (rank VARCHAR, primary_industry VARCHAR)
SELECT COUNT(rank) FROM table_name_42 WHERE primary_industry = "health care"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (rank VARCHAR, primary_industry VARCHAR) Question: How many ranks have an industry of health care? [/INST] SELECT COUNT(rank) FROM table_name_42 WHERE primary_industry = "health care" </s>