select EXTRACT(MONTH from p.date) as period, sum(p.sum) from rtneo$Payment p where p.inn in (select c.inn from rtneo$Contragent c where (lower(c.legalAddress) like '%%ольхонский%%' or lower(c.legalAddress) like '%%листвянка%%') and lower(c.legalAddress) not like '%%-листвянка%%') group by period

select EXTRACT(MONTH from p.date) as period, sum(p.sum) from rtneo$Payment p where p.inn in (select c.inn from rtneo$Contragent c where (lower(c.legalAddress) like '%%ольхонский%%' or lower(c.legalAddress) like '%%листвянка%%') and lower(c.legalAddress) not like '%%-листвянка%%' and not c.inn is null) and not p.inn is null group by period