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

Find the name of companies whose revenue is between 100 and 150.
SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150
SELECT "name" FROM "manufacturers" WHERE "revenue" <= 150 AND "revenue" >= 100