Database: manufactory_1
Question: What are the names of companies with revenue between 100 and 150?
SQL:
SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150