SELECT name FROM manufacturers WHERE revenue  <  (SELECT min(revenue) FROM manufacturers WHERE headquarter  =  'Austin')
What are the names of companies with revenue less than the lowest revenue of any manufacturer 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 )
What are the names of companies with revenue less than the lowest revenue of any manufacturer in Austin ?