CREATE TABLE Products (Code INT, Name VARCHAR, Price DECIMAL, Manufacturer INT)
CREATE TABLE Manufacturers (Code INT, Name VARCHAR, Headquarter VARCHAR, Founder VARCHAR, Revenue FLOAT)

A bar chart about 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") NULLS FIRST