zOs/SQL/ALTER01

select count(*), ALT05004, year(ALT05006)
            from S100447.alter01
    where ALT05007 = 'DBOF'
    group by ALT05004, year(ALT05006)
    order by 3 desc, 2
 -- fetch first 1000 rows only
    with ur