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

Find the name of the project for which a scientist whose name contains Smith is assigned to, and count them by a bar chart, could you order by the x-axis in descending?
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 ORDER BY T2.Name DESC
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" AND "T3"."Name" LIKE '%Smith%' GROUP BY "T2"."Name" ORDER BY "T2"."Name" DESC NULLS LAST