Task: Text to Code
Input (English): What is the total revenue of each manufacturer?
Output (English): SELECT sum(revenue) ,  name FROM manufacturers GROUP BY name