select
a.AGE_NAME `年齢階層`,
sum(case when d.TIME_CODE = 120 then d.TARGET_POP else 0 end) `5時間未満`,
sum(case when d.TIME_CODE = 130 then d.TARGET_POP else 0 end) `5時間以上6時間未満`,
sum(case when d.TIME_CODE = 140 then d.TARGET_POP else 0 end) `6時間以上7時間未満`,
sum(case when d.TIME_CODE = 150 then d.TARGET_POP else 0 end) `7時間以上8時間未満`,
sum(case when d.TIME_CODE = 160 then d.TARGET_POP else 0 end) `8時間以上9時間未満`,
sum(case when d.TIME_CODE = 170 then d.TARGET_POP else 0 end) `9時間以上`,
sum(case when d.TIME_CODE = 180 then d.TARGET_POP else 0 end) `不詳`

from SLEEP_TIME_DTL d

join AGE_GRP a
on d.AGE_CODE = a.AGE_CODE

group by
d.AGE_CODE

order by
d.AGE_CODE