how many companies are based in Austin?
select count(*) from manufacturers where headquarter = 'Austin'
show their revenues
select revenue from manufacturers where headquarter = 'Austin'
Find the names of companies whose revenue is smaller than all of those revenues.
select name from manufacturers where revenue < (select min(revenue) from manufacturers where headquarter = 'Austin')