zOs/SQL/ADBCHG

select count(*)
    from s100447.adbChg
;
select count(*), status
    from s100447.adbChg
    group by status
;
select count(*), status, left(char(alteredts), 7)
    from s100447.adbChg
    group by status, left(char(alteredts), 7)
    order by 3 desc, 2 asc
;