select
	t2.AGE_NAME as `年齢階層`,
	sum(case when t1.TIME_CODE = 120 then TARGET_POP else 0 end) as `5時間未満`,
	sum(case when t1.TIME_CODE = 130 then TARGET_POP else 0 end) as `5時間以上6時間未満`,
	sum(case when t1.TIME_CODE = 140 then TARGET_POP else 0 end) as `6時間以上7時間未満`,
	sum(case when t1.TIME_CODE = 150 then TARGET_POP else 0 end) as `7時間以上8時間未満`,
	sum(case when t1.TIME_CODE = 160 then TARGET_POP else 0 end) as `8時間以上9時間未満`,
	sum(case when t1.TIME_CODE = 170 then TARGET_POP else 0 end) as `9時間以上`,
	sum(case when t1.TIME_CODE = 180 then TARGET_POP else 0 end) as `不詳`
from
	SLEEP_TIME_DTL t1
inner join
	AGE_GRP t2
	on t1.AGE_CODE = t2.AGE_CODE
group by 1
order by t1.AGE_CODE