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
### Context: CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER) ### Question: Find the name of companies whose revenue is between 100 and 150. ### Answer: SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150