select cre.contragent.personalAccount, cre.contragent.name, cre.realEstate.address, cre.realEstate.cadastralNumber, cre.share, cre.realEstate.area, cre.calculationAmount, cre.category.name, cre.category.norm, cre.category.ratio from rtneo$ContragentRealEstate cre where not cre.category is null and cre.landlord is null and cre.createTs > '2020-09-01' order by cre.realEstate.id

select cre.realEstate, count(cre) from rtneo$ContragentRealEstate cre where not cre.category is null and cre.landlord is null group by cre.realEstate having count(cre)>10