zOs/SQL/PM1

select plan_name, count(distinct connect_type)  c ,
              min(connect_type), max(connect_type),
              count(*),
              sum(occurrences), sum(CLASS2_CPU),
              sum(occurrences * CLASS2_CPU)
    from DB2PMPDB.TACCT_EXTRACT
    where interval_time > current_timestamp - 30 days
    group by plan_name
    order by 8 desc
;
xelect distinct connect_type, plan_name
    from DB2PMPDB.TACCT_EXTRACT
    where interval_time > current_timestamp - 1 month
    order by connect_type, plan_name
;
xelect distinct plan
    from DB2PMPDB.TACCT_EXTRACT
    where interval_time > current_timestamp - 3 days
    order by plan
;
select distinct subsystem_id
    from DB2PMPDB.TACCT_EXTRACT
    where interval_time > current_timestamp - 3 days
    order by subsystem_id
;
xelect count(*), trunc_timestamp(interval_time, 'HH'),
          min(interval_time), max(interval_time),
          count(distinct interval_time)
    from DB2PMPDB.TACCT_EXTRACT
    where interval_time > current_timestamp - 3 days
    group by trunc_Timestamp(interval_time, 'HH')