CREATE TABLE products (code DECIMAL, name TEXT, price DECIMAL, manufacturer DECIMAL)
CREATE TABLE manufacturers (code DECIMAL, name TEXT, headquarter TEXT, founder TEXT, revenue DECIMAL)

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" = 'Austin'