with
    std as (
        select
            age_code
            ,case when time_code = 120 then target_pop else null end as '5時間未満'
            ,case when time_code = 130 then target_pop else null end as '5時間以上6時間未満'
            ,case when time_code = 140 then target_pop else null end as '6時間以上7時間未満'
            ,case when time_code = 150 then target_pop else null end as '7時間以上8時間未満'
            ,case when time_code = 160 then target_pop else null end as '8時間以上9時間未満'
            ,case when time_code = 170 then target_pop else null end as '9時間以上'
            ,case when time_code = 180 then target_pop else null end as '不詳'
        from
            sleep_time_dtl
    )
    ,sum_std as (
        select
            age_code
            ,sum("5時間未満") as '5時間未満'
            ,sum("5時間以上6時間未満") as '5時間以上6時間未満'
            ,sum("6時間以上7時間未満") as '6時間以上7時間未満'
            ,sum("7時間以上8時間未満") as '7時間以上8時間未満'
            ,sum("8時間以上9時間未満") as '8時間以上9時間未満'
            ,sum("9時間以上") as '9時間以上'
            ,sum("不詳") as '不詳'
        from
            std
        group by
            1
    )

select
    ag.age_name as '年齢階層'
    ,sum_std."5時間未満"
    ,sum_std."5時間以上6時間未満"
    ,sum_std."6時間以上7時間未満"
    ,sum_std."7時間以上8時間未満"
    ,sum_std."8時間以上9時間未満"
    ,sum_std."9時間以上"
    ,sum_std."不詳"
from
    sum_std
join
    age_grp ag
on
    sum_std.age_code = ag.age_code
order by
    1