SELECT name FROM manufacturers WHERE revenue  <  (SELECT min(revenue) FROM manufacturers WHERE headquarter  =  'Austin')
Find the name of companies whose revenue is smaller than the revenue of all companies based in Austin.
SELECT name FROM manufacturers WHERE revenue < ( SELECT min ( revenue ) FROM manufacturers WHERE headquarter = 'Austin ' )
select name from manufacturers where revenue < ( select min ( revenue ) from manufacturers where headquarter = value )
Find the name of companies whose revenue is smaller than the revenue of all companies based in Austin .