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

Create a bar chart showing maximal revenue across name, and I want to rank X in descending order please.
SELECT Name, MAX(Revenue) FROM Manufacturers GROUP BY Headquarter ORDER BY Name DESC
SELECT "Name", MAX("Revenue") FROM "Manufacturers" GROUP BY "Headquarter" ORDER BY "Name" DESC NULLS LAST