SQL & PL/SQL

What I'm trying to do is filter through the stragg output so that it only displays the "Offenders" or the tickets that are out of date as shown by the lines above it, but I also need to have 2 columns that do not search through these specific dates. They only need to have the one condition specified in the WHERE clause.
I don't know if there is a way to do this, or if I need to use a completely different method. Any help would be appreciated. In the results, the Offenders column shows all NOT Completed tickets grouped by the person who logged the ticket, but I only want it to show the tickets that are being counted in the High/Critical, Medium/Low, and Open columns.

I'm aware of the old syntax for the joins.. Pay no attention to that unless it absolutely is an issue.

SELECT SYSDATE
      ,au_a.user_nm AS "ASSIGNED TO"
      ,COUNT(DISTINCT t.tkt_sid) AS "Ticket Count"
      ,COUNT(DISTINCT(CASE WHEN
              ((t.rcd_lst_user_ts < TRUNC(SYSDATE - 1) AND ts.tkt_sts_dsc = 'In Progress' AND tp.prty_dsc = 'Critical')
            OR (t.rcd_lst_user_ts < TRUNC(SYSDATE - 4) AND ts.tkt_sts_dsc = 'In Progress' AND tp.prty_dsc = 'High')
            OR (t.rcd_lst_user_ts < TRUNC(SYSDATE - 8) AND ts.tkt_sts_dsc = 'Pending' AND tp.prty_dsc = 'High')
            OR (t.rcd_lst_user_ts < TRUNC(SYSDATE - 1) AND ts.tkt_sts_dsc = 'Open' AND tp.prty_dsc = 'High'))
       THEN t.tkt_sid else null end)) AS "High/Critical"
      ,COUNT(DISTINCT(CASE WHEN
              ((t.rcd_lst_user_ts < TRUNC(SYSDATE - 16) AND ts.tkt_sts_dsc = 'In Progress' AND tp.prty_dsc = 'Medium')
            OR (t.rcd_lst_user_ts < TRUNC(SYSDATE - 29) AND ts.tkt_sts_dsc = 'In Progress' AND tp.prty_dsc = 'Low')
            OR (t.rcd_lst_user_ts < TRUNC(SYSDATE - 22) AND ts.tkt_sts_dsc = 'Pending' AND tp.prty_dsc = 'Medium')
            OR (t.rcd_lst_user_ts < TRUNC(SYSDATE - 43) AND ts.tkt_sts_dsc = 'Pending' AND tp.prty_dsc = 'Low'))
       THEN t.tkt_sid else null end)) AS "Medium/Low"
      ,COUNT (DISTINCT(case when (ts.tkt_sts_dsc = 'Open') then 1 else null end)) AS "Open"
      ,sys.Stragg(DISTINCT t.tkt_sid || ' ') AS "Offenders"
     
FROM   afp_asd.tkt t
      ,afp_asd.tkt_prty tp
      ,afp_asd.tkt_sts ts
      ,afp_asd.tkt_log tl
      ,afp_asd.agt a
      ,afp_asd.asd_user au_a  

WHERE  TKT_STS_DSC NOT LIKE 'Completed'

AND    t.prty_cd = tp.prty_cd
AND    t.tkt_sts_cd = ts.tkt_sts_cd
AND    t.agt_sid = a.agt_sid
AND    t.assigned_id = au_a.asd_user_id
AND    t.tkt_sid = tl.tkt_sid
AND    tl.rcd_lst_user_ts >= :b_start_date

GROUP BY au_a.user_nm

So for Name3 it should only show 4 ticket numbers. If someone has all zeros, such as Name10.. It should just be blank or say NULL.