WITH t AS
(
SELECT '가' a, '(가)' b, '(1)' c, 2 d, '20120611' e FROM dual
UNION ALL SELECT '가', '(가)', '(1)', 3, '20120610' FROM dual
UNION ALL SELECT '가', '(가)', '(1)', 1, '20120609' FROM dual
UNION ALL SELECT '가', '(나)', '(1)', 1, '20120610' FROM dual
UNION ALL SELECT '가', '(나)', '(1)', 1, '20120611' FROM dual
UNION ALL SELECT '가', '(나)', '(1)', 2, '20120609' FROM dual
UNION ALL SELECT '나', '(가)', '(2)', 1, '20120610' FROM dual
)
SELECT a, b, c
     , NVL(SUM(CASE WHEN e < '20120610' THEN d END), 0) d1
     , NVL(SUM(CASE WHEN e = '20120610' THEN d END), 0) d2
     , NVL(SUM(CASE WHEN e > '20120610' THEN d END), 0) d3
  FROM t
 WHERE e >= TO_CHAR(TO_DATE('20120610', 'yyyymmdd') - 1, 'yyyymmdd')
   AND e <= TO_CHAR(TO_DATE('20120610', 'yyyymmdd') + 1, 'yyyymmdd')
 GROUP BY a, ROLLUP((b, c))
;