SELECT NAME, SUM, RE_DAY FROM ( SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-15','%Y-%m-%d') RE_DATE, 'Sunday' RE_DAY UNION ALL SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-16','%Y-%m-%d') RE_DATE, 'Monday' RE_DAY UNION ALL SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-17','%Y-%m-%d') RE_DATE, 'Tuesday' RE_DAY UNION ALL SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-18','%Y-%m-%d') RE_DATE, 'Wednesday' RE_DAY UNION ALL SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-19','%Y-%m-%d') RE_DATE, 'Thursday' RE_DAY UNION ALL SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-20','%Y-%m-%d') RE_DATE, 'Friday' RE_DAY UNION ALL SELECT '홍길동' NAME, 1194 SUM, STR_TO_DATE('2019-09-21','%Y-%m-%d') RE_DATE, 'Saturday' RE_DAY ) T WHERE RE_DATE BETWEEN ADDDATE(CURDATE(), - WEEKDAY(CURDATE()) - 1) AND ADDDATE(CURDATE(), - WEEKDAY(CURDATE()) + 5)
다른 이야기지만 RE_DAY를 굳이 컬럼으로 관리하실 필요가 있나요? 요일별 합계 뭐 이런 통계가 따로 필요하신 게 아니라면..