WITH t AS ( SELECT '2022-12' 년월, 5000000 총매출 UNION ALL SELECT '2023-01', 5500000 UNION ALL SELECT '2023-02', 12000000 UNION ALL SELECT '2023-03', 7000000 ) SELECT a.년월 , a.총매출 , a.총매출 - b.총매출 전월대비 FROM t a LEFT OUTER JOIN t b ON b.년월 = DATE_FORMAT(DATE_ADD( STR_TO_DATE(CONCAT(a.년월, '-01'), '%Y-%m-%d') , INTERVAL -1 MONTH), '%Y-%m') WHERE a.년월 >= '2022-12' AND a.년월 <= '2023-12' ;