Show me all the ids of projects with outcomes.
select project_id from project_outcomes;
How many projects do not have outcome?
select count(*) from projects where project_id not in ( select project_id from project_outcomes );
List their details.
select project_details from projects where project_id not in ( select project_id from project_outcomes );