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 staff ids of the project staff involved in the most number of project outcomes?
select t2.staff_id 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
What are the project ids that staff member worked on?
select project_id from project_staff where staff_id = '5137097.0'
What are the date from and date to of that project?
select date_from, date_to from project_staff where project_id = '7'
What is the outcome code for that project?
select outcome_code from project_outcomes where project_id = '7'