select
    AGE_GRP.AGE_NAME as "年齢階層"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  120 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "5時間未満"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  130 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "5時間以上6時間未満"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  140 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "6時間以上7時間未満"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  150 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "7時間以上8時間未満"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  160 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "8時間以上9時間未満"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  170 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "9時間以上"
    , sum(case when SLEEP_TIME_DTL.TIME_CODE =  180 then SLEEP_TIME_DTL.TARGET_POP else 0 end ) as "不詳"
from
    SLEEP_TIME_DTL
inner join AGE_GRP
    on SLEEP_TIME_DTL.AGE_CODE = AGE_GRP.AGE_CODE
group by
    SLEEP_TIME_DTL.AGE_CODE
order by
    SLEEP_TIME_DTL.AGE_CODE
;