I am getting zero results. I am trying to find students who were enrolled in both spring and summer but have not enrolled in the fall. The code works if I run it in sections. There is something I am missing when adding the not in fall part.
select distinct p.last_name,p.First_name,A.people_id,a.graduated,ENROLL_SEPARATION,academic_year,Academic_term from academic A
join people p on p.people_id=a.PEOPLE_ID
where (academic_year='2022' and academic_term = 'SPRING' and ENROLL_SEPARATION ='Enrl') and
(academic_year='2022' and academic_term = 'Summer' and ENROLL_SEPARATION ='Enrl') and
(academic_year='2022' and academic_term = ('FALL') and ENROLL_SEPARATION <> 'ENRL') and
graduated='N'