Melkij

select admin_id
count(*) filter(where created_at >= '2019-01-01' and created_at < '2019-02-01'),
count(*) filter(where created_at >= '2019-02-01' and created_at < '2019-03-01'),
....
from tablename where ... group by admin_id

alter table tablename add constraint tablename_p1_xor_p2 check((p1 is null and p2 is not null) or (p2 is null and p1 is not null));

Возможно ли не встравлять в таблицу записи, которые уже присутствуют в таблице?

SELECT Prop.*, coalesce("counters".countAllUnits, 0) AS "countAllUnits", coalesce("counters".countVacantUnits, 0) AS "countVacantUnits"
                    FROM "Property" AS Prop
                    INNER JOIN LATERAL
                    (
                     SELECT COUNT(*) AS countAllUnits,
count(*) filter(where "Unit".status = 'Vacant') as countVacantUnits
                     FROM "Unit"
                     WHERE Prop."id" = "Unit"."propertyId"
                    ) AS "counters" ON true
                    WHERE  Prop."userId" IN (
                          SELECT id FROM "User" WHERE  "companyId" = 200001
                    )
                    ORDER BY Prop."userId" ASC LIMIT 10 OFFSET 0

create table new_city (like city including all);
insert into new_city select * from city;

select n from generate_series(1,11) as n
where not exists (select from tablename where id = n)

(select ... from tablename where id < 88 order by id desc limit 50)
union all
(select ... from tablename where id > 88 order by id asc limit 50)
order by id