CREATE TABLE products (code DECIMAL, name TEXT, price DECIMAL, manufacturer DECIMAL)
CREATE TABLE manufacturers (code DECIMAL, name TEXT, headquarter TEXT, founder TEXT, revenue DECIMAL)

Find the name, headquarter and founder of the manufacturer that has the highest revenue.
SELECT name, headquarter, founder FROM manufacturers ORDER BY revenue DESC LIMIT 1
SELECT "name", "headquarter", "founder" FROM "manufacturers" ORDER BY "revenue" DESC NULLS LAST LIMIT 1