Database: manufactory_1
Question: Find the name of companies whose revenue is between 100 and 150.
SQL:
SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150