SELECT sum(revenue) FROM manufacturers WHERE headquarter  =  'Austin'
Find the total revenue created by the companies whose headquarter is located at Austin.
SELECT sum ( revenue ) FROM manufacturers WHERE headquarter = 'Austin '
select sum ( revenue ) from manufacturers where headquarter = value
Find the total revenue created by the companies whose headquarter is located at Austin .