SELECT project_details FROM Projects WHERE project_id NOT IN ( SELECT project_id FROM Project_Staff WHERE role_code  =  'researcher' )
What are the details for all projects that did not hire any staff in a research role?
SELECT project_details FROM Projects WHERE project_id NOT IN ( SELECT project_id FROM Project_Staff WHERE role_code = 'researcher ' )
select project_details from projects where project_id not in ( select project_id from project_staff where role_code = value )
What are the details for all projects that did not hire any staff in a research role ?