Database: manufactory_1
Question: Find the total revenue created by the companies whose headquarter is located at Austin.
SQL:
SELECT sum(revenue) FROM manufacturers WHERE headquarter  =  'Austin'