What are the names of all 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' ) 
names of all companies = SELECT name; revenue smaller than = revenue <; revenue of all companies based in Austin = min(revenue) WHERE headquarter = 'Austin';