-- Database schema
| Manufacturers : Code [ INT ] primary_key , Name [ TEXT ] , Headquarter [ TEXT ] , Founder [ TEXT ] , Revenue [ INT ] | Products : Code [ INT ] primary_key , Name [ TEXT ] , Price [ INT ] , Manufacturer [ INT ] Products.Manufacturer = Manufacturers.Code |
-- -- Find the total revenue of companies whose revenue is larger than the revenue of some companies based in Austin.

SELECT sum(revenue) FROM manufacturers WHERE revenue  >  (SELECT min(revenue) FROM manufacturers WHERE headquarter  =  'Austin');