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

What are the names of companies with revenue between 100 and 150?
SELECT name FROM manufacturers WHERE revenue BETWEEN 100 AND 150
SELECT "name" FROM "manufacturers" WHERE "revenue" <= 150 AND "revenue" >= 100