List out projects which did not hire staff for researcher role ?
select project_id from projects where project_id not in ( select project_id from project_staff where role_code = 'researcher' )
what is the role of the project id 5?
select role_code from project_staff where project_id = 5
Can you tell me the role of project id 1 ?
select role_code from project_staff where project_id = 1
List out projects which has staff for researcher role ?
select project_id from project_staff where role_code = 'researcher'
Can you tell me the organization id for the project id 1 ?
select organisation_id from projects where project_id = 1
can you tell me the staff id of the project which did not have researcher role ?
select t1.staff_id from project_staff as t1 join projects as t2 where t1.project_id not in ( select project_id from project_staff where role_code = 'researcher' )
tell me project details about the project id 1 ?
select project_details from projects where project_id = 1
List out total number of projects which has no staff for researcher role ?
select count ( * ) from projects where project_id not in ( select project_id from project_staff where role_code = 'researcher' )
List the project details of the projects which did not hire any staff for a researcher role ?
select project_details from projects where project_id not in ( select project_id from project_staff where role_code = 'researcher' )