CREATE TABLE assignedto (scientist NUMBER, project CLOB)
CREATE TABLE projects (code CLOB, name CLOB, hours NUMBER)
CREATE TABLE scientists (ssn NUMBER, name CLOB)

What are the names of projects that require between 100 and 300 hours?
SELECT name FROM projects WHERE hours BETWEEN 100 AND 300
SELECT "name" FROM "projects" WHERE "hours" <= 300 AND "hours" >= 100