WITH t AS
(
SELECT 1 idx, '사과' cd, '2020-03-01 13:10' dt, 36000 amt
UNION ALL SELECT  2, '복숭아', '2020-03-01 13:11', 52000
UNION ALL SELECT  3, '수박'  , '2020-03-01 13:14', 11000
UNION ALL SELECT  4, '참외'  , '2020-03-01 13:15', 11000
UNION ALL SELECT  5, '딸기'  , '2020-03-01 13:16', 11000
UNION ALL SELECT  6, '키위'  , '2020-03-01 13:17', 11000
UNION ALL SELECT  7, '메론'  , '2020-03-01 13:18', 11000
UNION ALL SELECT  8, '망고'  , '2020-03-01 13:19', 11000
UNION ALL SELECT  9, '애플'  , '2020-03-01 13:19', 11000
UNION ALL SELECT 10, '바나나', '2020-03-01 13:19', 23000
UNION ALL SELECT 11, '오렌지', '2020-03-01 13:20', 23000
UNION ALL SELECT 12, '오렌지', '2020-03-01 13:21', 23000
)
SELECT a.idx
     , a.cd
     , a.dt sdt
     , MAX(b.dt) edt
     , COUNT(DISTINCT b.cd) cnt
     , String_Agg(b.cd, ',') WITHIN GROUP(ORDER BY b.idx) x
  FROM t a
 INNER JOIN t b
    ON b.dt >= a.dt
   AND b.dt <  DATEADD(minute, 10, a.dt)
 WHERE a.dt LIKE '2020-03%'
   AND b.dt LIKE '2020-03%'
 GROUP BY a.idx, a.cd, a.dt
HAVING COUNT(DISTINCT b.cd) >= 10
;