Database: manufactory_1
Question: Find the total revenue of companies whose revenue is larger than the revenue of some companies based in Austin.
SQL:
SELECT sum(revenue) FROM manufacturers WHERE revenue  >  (SELECT min(revenue) FROM manufacturers WHERE headquarter  =  'Austin')