SELECT 
    A.AGE_NAME as `年齢階層`,
    SUM(CASE WHEN B.TIME_CODE = 120 THEN B.TARGET_POP END) as `5時間未満`,
    SUM(CASE WHEN B.TIME_CODE = 130 THEN B.TARGET_POP END) as `5時間以上6時間未満`,
    SUM(CASE WHEN B.TIME_CODE = 140 THEN B.TARGET_POP END) as `6時間以上7時間未満`,
    SUM(CASE WHEN B.TIME_CODE = 150 THEN B.TARGET_POP END) as `7時間以上8時間未満`,
    SUM(CASE WHEN B.TIME_CODE = 160 THEN B.TARGET_POP END) as `8時間以上9時間未満`,
    SUM(CASE WHEN B.TIME_CODE = 170 THEN B.TARGET_POP END) as `9時間以上`,
    SUM(CASE WHEN B.TIME_CODE = 180 THEN B.TARGET_POP END) as `不詳`
FROM AGE_GRP as A
	INNER JOIN
		SLEEP_TIME_DTL as B
	ON
		A.AGE_CODE = B.AGE_CODE
GROUP BY A.AGE_CODE
ORDER BY
	A.AGE_CODE ASC
;