Which projects have no outcome? List the project details.
CREATE TABLE Project_outcomes (project_details VARCHAR, project_id VARCHAR); CREATE TABLE Projects (project_details VARCHAR, project_id VARCHAR)
SELECT project_details FROM Projects WHERE NOT project_id IN (SELECT project_id FROM Project_outcomes)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Project_outcomes (project_details VARCHAR, project_id VARCHAR); CREATE TABLE Projects (project_details VARCHAR, project_id VARCHAR) Question: Which projects have no outcome? List the project details. [/INST] SELECT project_details FROM Projects WHERE NOT project_id IN (SELECT project_id FROM Project_outcomes) </s>