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