I think you just need this. There is no need for the subquery.
SELECT DISTINCT T0.project_number_ext as ProjectNumber ,T0.status_desc as SDesc ,T0.Project_name as PName From trimergo.rpt_getProjectPOC T0 WHERE T0.sproject_number IS NULL AND ( T1.SDesc LIKE '10 - In Proposal%' OR T1.SDesc like '90-Lost Opportunity%' )
solved How to filter twice using subquery? [closed]