zOs/SQL/ADBPRE

select count(*)
    from s100447.adbcprereq
;
select count(*), c
from
(
select count(*) c, changeid
    from s100447.adbcprereq
    group by changeid
) c
    group by c
    order by c desc
;
x
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
;