---

select
    'prod_line.pens_scheme' as dictionary,
    count(*) as total_rows,
    count(*) filter (
        where nullif(btrim(cast(uid_1c as text)), '') is not null
    ) as rows_with_uid
from prod_line.pens_scheme

union all

select
    'prod_line.hb_invest_strategy',
    count(*),
    count(*) filter (
        where nullif(btrim(cast(uid_1c as text)), '') is not null
    )
from prod_line.hb_invest_strategy;