SELECT
	a.AGE_NAME 年齢階層
	, SUM(CASE WHEN b.TIME_CODE = 120 THEN b.TARGET_POP ELSE 0 END) '5時間未満'
	, SUM(CASE WHEN b.TIME_CODE = 130 THEN b.TARGET_POP ELSE 0 END) '5時間以上6時間未満'
	, SUM(CASE WHEN b.TIME_CODE = 140 THEN b.TARGET_POP ELSE 0 END) '6時間以上7時間未満'
	, SUM(CASE WHEN b.TIME_CODE = 150 THEN b.TARGET_POP ELSE 0 END) '7時間以上8時間未満'
	, SUM(CASE WHEN b.TIME_CODE = 160 THEN b.TARGET_POP ELSE 0 END) '8時間以上9時間未満'
	, SUM(CASE WHEN b.TIME_CODE = 170 THEN b.TARGET_POP ELSE 0 END) '9時間以上'
	, SUM(CASE WHEN b.TIME_CODE = 180 THEN b.TARGET_POP ELSE 0 END) '不詳'

FROM
	AGE_GRP a 
		INNER JOIN SLEEP_TIME_DTL b
			ON a.AGE_CODE = b.AGE_CODE

GROUP BY
    a.AGE_NAME

ORDER BY
    a.AGE_CODE
;