Which projects have no outcome? List the project details.
create table project_outcomes (project_details varchar, project_id varchar, PRIMARY KEY (project_details)); create table projects (project_details varchar, project_id varchar, PRIMARY KEY (project_details))
select project_details from projects where not project_id in (select project_id from project_outcomes)