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

How many different projects are there?
SELECT COUNT(DISTINCT name) FROM projects
SELECT COUNT(DISTINCT "name") FROM "projects"