What're the project details?
select project_details from projects;
Show me only the one launched by the organisation with the most number of projects.
select project_details from projects where organisation_id in ( select organisation_id from projects group by organisation_id order by count(*) asc limit 1 );
How about the one with most projects?
select project_details from projects where organisation_id in ( select organisation_id from projects group by organisation_id order by count(*) desc limit 1 );