select
    AGE_NAME as '年齢階層'
    , st120.TARGET_POP as '5時間未満'
    , st130.TARGET_POP as '5時間以上6時間未満'
    , st140.TARGET_POP as '6時間以上7時間未満'
    , st150.TARGET_POP as '7時間以上8時間未満'
    , st160.TARGET_POP as '8時間以上9時間未満'
    , st170.TARGET_POP as '9時間以上'
    , st180.TARGET_POP as '不詳'
from (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 120
    group by 1
) as st120
left join (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 130
    group by 1
) as st130 using(AGE_CODE)
left join (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 140
    group by 1
) as st140 using(AGE_CODE)
left join (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 150
    group by 1
) as st150 using(AGE_CODE)
left join (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 160
    group by 1
) as st160 using(AGE_CODE)
left join (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 170
    group by 1
) as st170 using(AGE_CODE)
left join (
    select
        AGE_CODE
        , sum(TARGET_POP) as TARGET_POP
    from
        SLEEP_TIME_DTL
    where
        TIME_CODE = 180
    group by 1
) as st180 using(AGE_CODE)
left join AGE_GRP
    using(AGE_CODE)
order by AGE_CODE