select count(c) from rtneo$ContragentRealEstate c where c in (select r.renterRecord from rtneo$RealEstateRenter r where c.id = r.renterRecord.id)

13419

110821

Всего 124240

select sum(c.realEstate.area), count(distinct(c.realEstate.id)) from rtneo$ContragentRealEstate c

select sum(r.area), count(r) from rtneo$RealEstate r where r in (select distinct c.realEstate from rtneo$ContragentRealEstate c)

==========================================

Вся жилая площадь

51515292.87

Жилая площадь Иркутск, Ангарск

3765874.26

select sum(r.area) from rtneo$RealEstate r join rtneo$ContragentRealEstate cre where r in (select distinct c.realEstate from rtneo$ContragentRealEstate c where

(c.realEstate.address like '%г% Иркутск%' or c.realEstate.address like '%г% Ангарск%')

and (not c.category.isLiving = true or c.category.isLiving is null))

===========================================