CREATE TABLE products (code NUMBER, name CLOB, price NUMBER, manufacturer NUMBER)
CREATE TABLE manufacturers (code NUMBER, name CLOB, headquarter CLOB, founder CLOB, revenue NUMBER)

What are the names, headquarters and revenues for manufacturers, sorted by revenue descending?
SELECT name, headquarter, revenue FROM manufacturers ORDER BY revenue DESC
SELECT "name", "headquarter", "revenue" FROM "manufacturers" ORDER BY "revenue" DESC