zOs/SQL/CATCOPPA

select min(jobName), max(jobName), dsName,
        count(distinct dsNum), min(dsNum), max(dsNum),
        min(timestamp), max(timestamp)
    from sysibm.syscopy
    where icType in ('F', 'I')
        and timestamp > current timestamp - 5 days
        and jobName like 'QR%'
    group by dsName
    order by 4 desc
    fetch first 100 rows only
    with ur