SELECT SONG, '케이팝' AS KPOP, IFNULL( SUM(SONG_00), 0) AS H_00, IFNULL ( SUM(SONG_01), 0) AS H_01, IFNULL( SUM(SONG_02), 0) AS H_02, IFNULL ( SUM(SONG_03), 0) AS H_03, IFNULL( SUM(SONG_04), 0) AS H_04, IFNULL ( SUM(SONG_05), 0) AS H_05, IFNULL( SUM(SONG_06), 0) AS H_06, IFNULL ( SUM(SONG_07), 0) AS H_07, IFNULL( SUM(SONG_08), 0) AS H_08, IFNULL ( SUM(SONG_09), 0) AS H_09, IFNULL( SUM(SONG_10), 0) AS H_10, IFNULL ( SUM(SONG_11), 0) AS H_11, IFNULL( SUM(SONG_12), 0) AS H_12, IFNULL ( SUM(SONG_13), 0) AS H_13, IFNULL( SUM(SONG_14), 0) AS H_14, IFNULL ( SUM(SONG_15), 0) AS H_15, IFNULL( SUM(SONG_16), 0) AS H_16, IFNULL ( SUM(SONG_17), 0) AS H_17, IFNULL( SUM(SONG_18), 0) AS H_18, IFNULL ( SUM(SONG_19), 0) AS H_19, IFNULL( SUM(SONG_20), 0) AS H_20, IFNULL ( SUM(SONG_21), 0) AS H_21, IFNULL( SUM(SONG_22), 0) AS H_22, IFNULL ( SUM(SONG_23), 0) AS H_23, IFNULL( SUM( SONG_TOT ), 0) AS H_TOT FROM SONG_PLAY WHERE SONG_ID IN ( SELECT SA.SONG FROM SONG_LIST SA LEFT JOIN SONG_INFO SB ON SA.SONG_ID = SB.SONG_ID WHERE SA.SONG_CODE = 'F00000513' AND SB.SONG_DIV IN ('1')) AND SONG_ID LIKE CONCAT ('DADASDASSAD') AND SONGS_NO LIKE CONCAT('0') AND SONG_DAY BETWEEN '20210413' AND '20210413'
위에꺼 실행시켯을때 H_01,H_TOT까지 모두 출력되는데
H_04에서 H_10까지의 데이터 이런식으로 원하는 시간대에 해당되는 데이터만 불러오고싶어요ㅠㅠ