SELECT 
a.AGE_NAME AS '年齢階層'

, SUM(CASE WHEN s.TIME_CODE = 120 THEN d.TARGET_POP END) AS '5時間未満'
, SUM(CASE WHEN s.TIME_CODE = 130 THEN d.TARGET_POP END) AS '5時間以上6時間未満'
, SUM(CASE WHEN s.TIME_CODE = 140 THEN d.TARGET_POP END) AS '6時間以上7時間未満'
, SUM(CASE WHEN s.TIME_CODE = 150 THEN d.TARGET_POP END) AS '7時間以上8時間未満'
, SUM(CASE WHEN s.TIME_CODE = 160 THEN d.TARGET_POP END) AS '8時間以上9時間未満'
, SUM(CASE WHEN s.TIME_CODE = 170 THEN d.TARGET_POP END) AS '9時間以上'
, SUM(CASE WHEN s.TIME_CODE = 180 THEN d.TARGET_POP END) AS '不詳'

FROM AGE_GRP a
CROSS JOIN SLEEP_TIME s
INNER JOIN SLEEP_TIME_DTL d ON a.AGE_CODE = d.AGE_CODE AND s.TIME_CODE = d.TIME_CODE
GROUP BY a.AGE_CODE
ORDER BY a.AGE_CODE ASC
;