Find the total revenue created by the companies whose headquarter is located at Austin.
CREATE TABLE manufacturers (revenue INTEGER, headquarter VARCHAR)
SELECT SUM(revenue) FROM manufacturers WHERE headquarter = 'Austin'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturers (revenue INTEGER, headquarter VARCHAR) Question: Find the total revenue created by the companies whose headquarter is located at Austin. [/INST] SELECT SUM(revenue) FROM manufacturers WHERE headquarter = 'Austin' </s>