Could you list the project details of the projects launched by the most popular organization?
select project_details from projects where organisation_id in ( select organisation_id from projects group by organisation_id order by count ( * ) desc limit 1 )
What are the ids of those?
select project_id from projects where organisation_id in ( select organisation_id from projects group by organisation_id order by count ( * ) desc limit 1 )
What are their organization ids?
select organisation_id from projects group by organisation_id order by count ( * ) desc limit 1
Can you tell me the project details of the lowest numbered project id?
select project_details from projects order by project_id limit 1