Исключить исключенные из учета

Не создавать если не заполнены категории, КП. Подумать еще случаи

select distinct c from rtneo$Contragent c where not c.type = 3 and size(c.contracts) <=2 and size(c.realEstates)>0

EXCEPT select distinct c from rtneo$Contragent c inner join sec$SessionLogEntry s where c.user is not null and c.user = s.user

select count(c) from rtneo$Contragent c where not c.type = 3 and size(c.contracts) <=2 and (c.user.login is null or (select count(s) from sec$SessionLogEntry s where s.user.login = c.user.login) = 0) and size(c.realEstates)>0