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