Project details of project ID 1?
select project_details from projects where project_id = 1
List the project details of above?
select project_details from projects where project_id not in ( select project_id from project_outcomes )
Organisation ID of project ID 2?
select organisation_id from projects where project_id = 2