CREATE TABLE Manufacturers (Code NUMBER, Name VARCHAR2, Headquarter VARCHAR2, Founder VARCHAR2, Revenue FLOAT)
CREATE TABLE Products (Code NUMBER, Name VARCHAR2, Price NUMBER, Manufacturer NUMBER)

What is the total revenue of each manufacturer, and show by the total number of revenue in asc.
SELECT Name, SUM(Revenue) FROM Manufacturers GROUP BY Name ORDER BY SUM(Revenue)
SELECT "Name", SUM("Revenue") FROM "Manufacturers" GROUP BY "Name" ORDER BY SUM("Revenue")