What is the organisation type and id of the organisation which has the most number of research staff?
create table research_staff (employer_organisation_id varchar, PRIMARY KEY (employer_organisation_id)); create table organisations (organisation_type varchar, organisation_id varchar, PRIMARY KEY (organisation_type))
select t1.organisation_type, 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