CREATE TABLE Projects (Code CHAR, Name CHAR, Hours NUMBER)
CREATE TABLE AssignedTo (Scientist NUMBER, Project CHAR)
CREATE TABLE Scientists (SSN NUMBER, Name CHAR)

A pie chart for finding the number of the name of the project for which a scientist whose name contains Smith is assigned to.
SELECT T2.Name, COUNT(T2.Name) FROM AssignedTo AS T1 JOIN Projects AS T2 ON T1.Project = T2.Code JOIN Scientists AS T3 ON T1.Scientist = T3.SSN WHERE T3.Name LIKE '%Smith%' GROUP BY T2.Name
SELECT "T2"."Name", COUNT("T2"."Name") FROM "AssignedTo" "T1" JOIN "Projects" "T2" ON "T1"."Project" = "T2"."Code" JOIN "Scientists" "T3" ON "T1"."Scientist" = "T3"."SSN" AND "T3"."Name" LIKE '%Smith%' GROUP BY "T2"."Name"