SELECT ROW_NUMBER() OVER(ORDER BY b.stdr_de) rn
     , b.stdr_de
     , COUNT(*) tot
     , COUNT(DECODE(a.info_ty, 'E11', 1)) E11
     , COUNT(DECODE(a.info_ty, 'E12', 1)) E12
     , COUNT(DECODE(a.info_ty, 'E13', 1)) E13
  FROM rdps_rw_event_info a
     , hss_st_oprat_info  b
 WHERE a.info_ty IN ('E11', 'E12', 'E13')
   AND b.stdr_de BETWEEN '2021-06-11' AND '2021-06-13'
   AND a.key = b.key
 GROUP BY b.stdr_de
 ORDER BY b.stdr_de DESC
;