WITH t AS
(
SELECT 1 id, '2022-01-24' dt, '새우깡' nm, 10 cnt
UNION ALL SELECT 2, '2022-01-24', '새우깡', 20
UNION ALL SELECT 3, '2022-01-24', '새우깡', 30
UNION ALL SELECT 4, '2022-01-24', '새우꽁', 20
UNION ALL SELECT 5, '2022-01-24', '새우꽁', 30
UNION ALL SELECT 6, '2022-01-25', '새우꽁', 20
UNION ALL SELECT 7, '2022-01-25', '새우꽁', 30
)
SELECT id
     , dt
     , nm
     , cnt
     , SUM(cnt) OVER(ORDER BY id) tot                       -- 누계
     , SUM(cnt) OVER(PARTITION BY nm ORDER BY id) tot1      -- 품목별 누계
     , SUM(cnt) OVER(PARTITION BY dt, nm ORDER BY id) tot2  -- 일별/품목별 누계
  FROM t
;