select ag.AGE_NAME as 年齢階層
,sum(std120.TARGET_POP) as '5時間未満'
,sum(std130.TARGET_POP) as '5時間以上6時間未満'
,sum(std140.TARGET_POP) as '6時間以上7時間未満'
,sum(std150.TARGET_POP) as '7時間以上8時間未満'
,sum(std160.TARGET_POP) as '8時間以上9時間未満'
,sum(std170.TARGET_POP) as '9時間以上'
,sum(std180.TARGET_POP) as '不詳'
from
AGE_GRP ag
inner join SLEEP_TIME_DTL std120 on ag.AGE_CODE = std120.AGE_CODE and std120.TIME_CODE = '120' 
inner join SLEEP_TIME_DTL std130 on ag.AGE_CODE = std130.AGE_CODE and std130.TIME_CODE = '130' 
inner join SLEEP_TIME_DTL std140 on ag.AGE_CODE = std140.AGE_CODE and std140.TIME_CODE = '140' 
inner join SLEEP_TIME_DTL std150 on ag.AGE_CODE = std150.AGE_CODE and std150.TIME_CODE = '150' 
inner join SLEEP_TIME_DTL std160 on ag.AGE_CODE = std160.AGE_CODE and std160.TIME_CODE = '160' 
inner join SLEEP_TIME_DTL std170 on ag.AGE_CODE = std170.AGE_CODE and std170.TIME_CODE = '170' 
inner join SLEEP_TIME_DTL std180 on ag.AGE_CODE = std180.AGE_CODE and std180.TIME_CODE = '180' 
where std120.AGE_CODE = ag.AGE_CODE
and std130.AGE_CODE = ag.AGE_CODE
and std140.AGE_CODE = ag.AGE_CODE
and std150.AGE_CODE = ag.AGE_CODE
and std160.AGE_CODE = ag.AGE_CODE
and std170.AGE_CODE = ag.AGE_CODE
and std180.AGE_CODE = ag.AGE_CODE

group by ag.AGE_CODE