Show me the project ids of all projects.
select project_id from projects;
Which of those had the most number of outcomes?
select t1.project_id from projects as t1 join project_outcomes as t2 on t1.project_id = t2.project_id group by t1.project_id order by count(*) desc limit 1;
Show me the project details as well.
select t1.project_details, t1.project_id from projects as t1 join project_outcomes as t2 on t1.project_id = t2.project_id group by t1.project_id order by count(*) desc limit 1;