Find the name of companies whose revenue is between 100 and 150.
CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER)
SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER) Question: Find the name of companies whose revenue is between 100 and 150. [/INST] SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150 </s>