Find the total revenue for each manufacturer.
SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name
SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name
[{'sum(revenue)': 100.0, 'Name': 'Creative Labs'}, {'sum(revenue)': 130.0, 'Name': 'Fujitsu'}, {'sum(revenue)': 50.0, 'Name': 'Hewlett-Packard'}, {'sum(revenue)': 200.0, 'Name': 'Iomega'}, {'sum(revenue)': 120.0, 'Name': 'Sony'}, {'sum(revenue)': 30.0, 'Name': 'Winchester'}]