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

Find the number of distinct projects.
SELECT COUNT(DISTINCT name) FROM projects
SELECT COUNT(DISTINCT "name") FROM "projects"