select
    a.age_name as "年齢階層",
    sum(case when std.time_code == 120 then std.target_pop else 0 end) as "5時間未満",
    sum(case when std.time_code == 130 then std.target_pop else 0 end) as "5時間以上6時間未満",
    sum(case when std.time_code == 140 then std.target_pop else 0 end) as "6時間以上7時間未満",
    sum(case when std.time_code == 150 then std.target_pop else 0 end) as "7時間以上8時間未満",
    sum(case when std.time_code == 160 then std.target_pop else 0 end) as "8時間以上9時間未満",
    sum(case when std.time_code == 170 then std.target_pop else 0 end) as "9時間以上",
    sum(case when std.time_code == 180 then std.target_pop else 0 end) as "不詳"
from
    sleep_time_dtl as std
    inner join
        age_grp as a
        on a.age_code == std.age_code
    inner join
        sleep_time as st
        on st.time_code == std.time_code
group by
    std.age_code
order by
    std.age_code asc
;