CREATE TABLE manufacturers (name VARCHAR2, headquarter VARCHAR2, revenue VARCHAR2)

Find all manufacturers' names and their headquarters, sorted by the ones with highest revenue first.
SELECT name, headquarter FROM manufacturers ORDER BY revenue DESC
SELECT "name", "headquarter" FROM "manufacturers" ORDER BY "revenue" DESC