I would like to know the most number of outcomes for all outcome codes
select count ( outcome_code ) from project_outcomes group by outcome_code order by count ( outcome_code ) desc limit 1
the project that had the highest 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
and can you please also give me the project details?
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