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

Count the number of different scientists assigned to any project.
SELECT COUNT(DISTINCT scientist) FROM assignedto
SELECT COUNT(DISTINCT "scientist") FROM "assignedto"