SELECT 
     age.AGE_NAME    "年齢階層"
    ,SUM(s120.TARGET_POP) "5時間未満"
    ,SUM(s130.TARGET_POP) "5時間以上6時間未満"
    ,SUM(s140.TARGET_POP) "6時間以上7時間未満"
    ,SUM(s150.TARGET_POP) "7時間以上8時間未満"
    ,SUM(s160.TARGET_POP) "8時間以上9時間未満"
    ,SUM(s170.TARGET_POP) "9時間以上"
    ,SUM(s180.TARGET_POP) "不詳"

FROM AGE_GRP age
INNER JOIN SLEEP_TIME_DTL s120
 ON s120.AGE_CODE = age.AGE_CODE 
 AND s120.TIME_CODE = '120'
INNER JOIN SLEEP_TIME_DTL s130
 ON s130.AGE_CODE = age.AGE_CODE 
 AND s130.TIME_CODE = '130'
 INNER JOIN SLEEP_TIME_DTL s140
 ON s140.AGE_CODE = age.AGE_CODE 
 AND s140.TIME_CODE = '140'
 INNER JOIN SLEEP_TIME_DTL s150
 ON s150.AGE_CODE = age.AGE_CODE 
 AND s150.TIME_CODE = '150'
 INNER JOIN SLEEP_TIME_DTL s160
 ON s160.AGE_CODE = age.AGE_CODE 
 AND s160.TIME_CODE = '160'
 INNER JOIN SLEEP_TIME_DTL s170
 ON s170.AGE_CODE = age.AGE_CODE 
 AND s170.TIME_CODE = '170'
 INNER JOIN SLEEP_TIME_DTL s180
 ON s180.AGE_CODE = age.AGE_CODE 
 AND s180.TIME_CODE = '180'

GROUP BY age.AGE_NAME
ORDER BY age.AGE_CODE
;