I have to find the indentid from the status table based on below two conditions:

1. If there are more than one record having same indentid in status table and the same indentID has count>1 in feasibilitystatus table then I don't want to display the record.
2. If there is only one record of indentid in status table and the same indentID has count>0 in feasibilitystatus table then I don't want to display the record.

Query:

select distinct s.indentid
from status s 
where s.status='true'
 and s.indentid
  not in( select case when count(s.indentid)>1 then 
                      (select indentid from feasibilitystatus
                       group by indentid having count(indentid)>1)
                 else (select indentid from feasibilitystatus
                       group by indentid having count(indentid)>0)    
                 end as indentid from status)

Error:

An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.