select
    AGE_GRP.AGE_NAME as "年齢階層"
    ,sum(case when SL.TIME_CODE = 120 then SL.TARGET_POP else 0 end)as "5時間未満"
    ,sum(case when SL.TIME_CODE = 130 then SL.TARGET_POP else 0 end)as "5時間以上6時間未満"
    ,sum(case when SL.TIME_CODE = 140 then SL.TARGET_POP else 0 end)as "6時間以上7時間未満"
    ,sum(case when SL.TIME_CODE = 150 then SL.TARGET_POP else 0 end)as "7時間以上8時間未満"
    ,sum(case when SL.TIME_CODE = 160 then SL.TARGET_POP else 0 end)as "8時間以上9時間未満"
    ,sum(case when SL.TIME_CODE = 170 then SL.TARGET_POP else 0 end)as "9時間以上"
    ,sum(case when SL.TIME_CODE = 180 then SL.TARGET_POP else 0 end)as "不詳"

from
    SLEEP_TIME_DTL as SL
        inner join AGE_GRP
        on SL.AGE_CODE = AGE_GRP.AGE_CODE
        
        inner join SLEEP_TIME
        on SL.TIME_CODE = SLEEP_TIME.TIME_CODE

group by 
    AGE_GRP.AGE_NAME
order by
    SL.AGE_CODE asc
;