select
    (select age_name from age_grp ag where ag.age_code = std.age_code) `年齢階層`,
    sum(case when std.time_code=120 then std.target_pop else 0 end) `5時間未満`,
    sum(case when std.time_code=130 then std.target_pop else 0 end) `5時間以上6時間未満`,
    sum(case when std.time_code=140 then std.target_pop else 0 end) `6時間以上7時間未満`,
    sum(case when std.time_code=150 then std.target_pop else 0 end) `7時間以上8時間未満`,
    sum(case when std.time_code=160 then std.target_pop else 0 end) `8時間以上9時間未満`,
    sum(case when std.time_code=170 then std.target_pop else 0 end) `9時間以上`,
    sum(case when std.time_code=180 then std.target_pop else 0 end) `不詳`
from sleep_time_dtl std
group by age_code
order by age_code