CREATE TABLE Projects (project_details VARCHAR2, project_id VARCHAR2)
CREATE TABLE Tasks (project_id VARCHAR2)

How many tasks does each project have? List the task count and the project detail.
SELECT COUNT(*), T1.project_details FROM Projects AS T1 JOIN Tasks AS T2 ON T1.project_id = T2.project_id GROUP BY T1.project_id
SELECT COUNT(*), "T1"."project_details" FROM "Projects" "T1" JOIN "Tasks" "T2" ON "T1"."project_id" = "T2"."project_id" GROUP BY "T1"."project_id"