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

What is the total revenue of each manufacturer, could you display total number from high to low order?
SELECT Name, SUM(Revenue) FROM Manufacturers GROUP BY Name ORDER BY SUM(Revenue) DESC
SELECT "Name", SUM("Revenue") FROM "Manufacturers" GROUP BY "Name" ORDER BY SUM("Revenue") DESC NULLS LAST