select
	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 as t1
inner join AGE_GRP as t2
	on t1.AGE_CODE = t2.AGE_CODE
inner join SLEEP_TIME as t3
	on t1.TIME_CODE = t3.TIME_CODE
group by t1.AGE_CODE
order by
    	t1.AGE_CODE