Which organization hired the most research staff?
select * 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
Can you give me just the organization id?
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 ( * ) desc limit 1
great, can you give me the organization type and detail too?
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