How many companies are headquartered in the US?
CREATE TABLE company (Headquarters VARCHAR)
SELECT COUNT(*) FROM company WHERE Headquarters = 'USA'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE company (Headquarters VARCHAR) Question: How many companies are headquartered in the US? [/INST] SELECT COUNT(*) FROM company WHERE Headquarters = 'USA' </s>