SELECT nvl(SUM(dt.quantity), 0) as qtys,

case when 

runc(SYSDATE) - trunc(t.event_time) > 30

   AND trunc(SYSDATE) - trunc(t.event_time) <= 45

then '30-45天'

when trunc(SYSDATE) - trunc(t.event_time) <=15 then '0-15天'

end as ttype

  FROM fy_product_storage_iron t, hme_pkn_container_dtl dt

 WHERE t.attribute3 = 'IN'

   AND t.pkn_kid = dt.kid

group by 

case when 

runc(SYSDATE) - trunc(t.event_time) > 30

   AND trunc(SYSDATE) - trunc(t.event_time) <= 45

then '30-45天'

when trunc(SYSDATE) - trunc(t.event_time) <=15 then '0-15天'

end

-- 类型我没写完，把条件写在case when里面就行

SELECT nvl(SUM(dt.quantity), 0)

  FROM fy_product_storage_iron t, hme_pkn_container_dtl dt

 WHERE t.attribute3 = 'IN'

   AND t.pkn_kid = dt.kid

   AND trunc(SYSDATE) - trunc(t.event_time) <= 15;

union all

SELECT nvl(SUM(dt.quantity), 0)

  FROM fy_product_storage_iron t, hme_pkn_container_dtl dt

 WHERE t.attribute3 = 'IN'

   AND t.pkn_kid = dt.kid

   AND trunc(SYSDATE) - trunc(t.event_time) > 15

   AND trunc(SYSDATE) - trunc(t.event_time) <= 30;

union all

SELECT nvl(SUM(dt.quantity), 0)

  FROM fy_product_storage_iron t, hme_pkn_container_dtl dt

 WHERE t.attribute3 = 'IN'

   AND t.pkn_kid = dt.kid

   AND trunc(SYSDATE) - trunc(t.event_time) > 30

   AND trunc(SYSDATE) - trunc(t.event_time) <= 45;

union all

SELECT nvl(SUM(dt.quantity), 0)

  FROM fy_product_storage_iron t, hme_pkn_container_dtl dt

 WHERE t.attribute3 = 'IN'

   AND t.pkn_kid = dt.kid

   AND trunc(SYSDATE) - trunc(t.event_time) > 45