select
    a.age_name as 年齢階層,
    sum(case when s.time_name = '5時間未満' then d.target_pop end) as `5時間未満`,
    sum(case when s.time_name = '5時間以上6時間未満' then d.target_pop end) as `5時間以上6時間未満`,
    sum(case when s.time_name = '6時間以上7時間未満' then d.target_pop end) as `6時間以上7時間未満`,
    sum(case when s.time_name = '7時間以上8時間未満' then d.target_pop end) as `7時間以上8時間未満`,
    sum(case when s.time_name = '8時間以上9時間未満' then d.target_pop end) as `8時間以上9時間未満`,
    sum(case when s.time_name = '9時間以上' then d.target_pop end) as `9時間以上`,
    sum(case when s.time_name = '不詳' then d.target_pop end) as `不詳`
from
    sleep_time_dtl as d
    inner join age_grp as a on d.age_code = a.age_code
    inner join sleep_time as s on d.time_code = s.time_code
group by
    年齢階層
order by
    年齢階層 asc
;