Find the total revenue of companies whose revenue is larger than the revenue of some companies based in Austin.
CREATE TABLE manufacturers (revenue INTEGER, headquarter VARCHAR)
SELECT SUM(revenue) FROM manufacturers WHERE revenue > (SELECT MIN(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 of companies whose revenue is larger than the revenue of some companies based in Austin. [/INST] SELECT SUM(revenue) FROM manufacturers WHERE revenue > (SELECT MIN(revenue) FROM manufacturers WHERE headquarter = 'Austin') </s>