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
For each project id, how many tasks are there?
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 as t1 join tasks as t2 on t1 . project_id = t2 . project_id group by t1 . project_id
For each project id , how many tasks are there ?