Database: manufactory_1
Question: Find the name of companies whose revenue is smaller than the revenue of all companies based in Austin.
SQL:
SELECT name FROM manufacturers WHERE revenue  <  (SELECT min(revenue) FROM manufacturers WHERE headquarter  =  'Austin')