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

What is the name of the project that has a scientist assigned to it whose name contains 'Smith', and count them by a pie chart
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"