Show me the number of research staff each organisation hired.
select count(*) from organisations as t1 join research_staff as t2 on t1.organisation_id = t2.employer_organisation_id group by t1.organisation_id;
Which organisation hired the least number? Show ids.
select t1.organisation_id from organisations as t1 join research_staff as t2 on t1.organisation_id = t2.employer_organisation_id group by t1.organisation_id order by count(*) asc limit 1;
How about the most number of research staff. List the organisation id, type and detail.
select t1.organisation_id, t1.organisation_type, t1.organisation_details from organisations as t1 join research_staff as t2 on t1.organisation_id = t2.employer_organisation_id group by t1.organisation_id order by count(*) desc limit 1;