SELECT
	b.AGE_NAME as '年齢階層',
	a.TIME_CODE_120 as '5時間未満',
	a.TIME_CODE_130 as '5時間以上6時間未満',
	a.TIME_CODE_140 as '6時間以上7時間未満',
	a.TIME_CODE_150 as '7時間以上8時間未満',
	a.TIME_CODE_160 as '8時間以上9時間未満',
	a.TIME_CODE_170 as '9時間以上',
	a.TIME_CODE_180 as '不詳'
FROM
	(SELECT
		AGE_CODE,
		sum(case when TIME_CODE = 120 then TARGET_POP else 0 end ) as TIME_CODE_120,
		sum(case when TIME_CODE = 130 then TARGET_POP else 0 end ) as TIME_CODE_130,
		sum(case when TIME_CODE = 140 then TARGET_POP else 0 end ) as TIME_CODE_140,
		sum(case when TIME_CODE = 150 then TARGET_POP else 0 end ) as TIME_CODE_150,
		sum(case when TIME_CODE = 160 then TARGET_POP else 0 end ) as TIME_CODE_160,
		sum(case when TIME_CODE = 170 then TARGET_POP else 0 end ) as TIME_CODE_170,
		sum(case when TIME_CODE = 180 then TARGET_POP else 0 end ) as TIME_CODE_180
	FROM
		SLEEP_TIME_DTL
	GROUP BY
		AGE_CODE
	) as a 
left join 
	AGE_GRP as b 
on
	a.AGE_CODE = b.AGE_CODE
order by 
	a.AGE_CODE asc