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

How many different scientists are assigned to any project?
SELECT COUNT(DISTINCT scientist) FROM assignedto
SELECT COUNT(DISTINCT "scientist") FROM "assignedto"