WITH t AS
(
SELECT '20171001' dt, '홍길동' nm, 10000 amt FROM dual
UNION ALL SELECT '20171002', '홍길동', 20000 FROM dual
UNION ALL SELECT '20171003', '임꺽정', 10000 FROM dual
UNION ALL SELECT '20171101', '홍길동', 25000 FROM dual
UNION ALL SELECT '20171102', '임꺽정', 30000 FROM dual
UNION ALL SELECT '20171203', '홍길동', 30000 FROM dual
)
SELECT :v_ym ym
     , nm
     , SUM(DECODE(SUBSTR(dt, 1, 6), :v_ym, amt)) amt_m
     , SUM(amt) amt_y
  FROM t
 WHERE dt >= SUBSTR(:v_ym, 1, 4)||'0101'
   AND dt <= :v_ym||'31'
 GROUP BY nm
;