Show the role description of the project staff involved in the most number of project outcomes
select t1.role_description from staff_roles as t1 join project_staff as t2 on t1.role_code = t2.role_code join project_outcomes as t3 on t2.project_id = t3.project_id group by t2.staff_id order by count ( * ) desc limit 1
Show the role code of the project staff involved in the most number of project outcomes
select t1.role_code from staff_roles as t1 join project_staff as t2 on t1.role_code = t2.role_code join project_outcomes as t3 on t2.project_id = t3.project_id group by t2.staff_id order by count ( * ) desc limit 1
Show me other details of the project staff involved in the most number of project outcomes
select t2.other_details from staff_roles as t1 join project_staff as t2 on t1.role_code = t2.role_code join project_outcomes as t3 on t2.project_id = t3.project_id group by t2.staff_id order by count ( * ) desc limit 1