select ag.AGE_NAME as '年齢階層', 
s12.s as '5時間未満', 
s13.s as '5時間以上6時間未満', 
s14.s as '6時間以上7時間未満', 
s15.s as '7時間以上8時間未満', 
s16.s as '8時間以上9時間未満',
s17.s as '9時間以上',
s18.s as '不詳'
from
(select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 120 GROUP BY TIME_CODE, AGE_CODE) as s12
left outer join AGE_GRP as ag
on ag.AGE_CODE = s12.AGE_CODE
left outer join (select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 130 GROUP BY TIME_CODE, AGE_CODE) as s13
on ag.AGE_CODE = s13.AGE_CODE
left outer join (select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 140 GROUP BY TIME_CODE, AGE_CODE) as s14
on ag.AGE_CODE = s14.AGE_CODE
left outer join (select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 150 GROUP BY TIME_CODE, AGE_CODE) as s15
on ag.AGE_CODE = s15.AGE_CODE
left outer join (select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 160 GROUP BY TIME_CODE, AGE_CODE) as s16
on ag.AGE_CODE = s16.AGE_CODE
left outer join (select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 170 GROUP BY TIME_CODE, AGE_CODE) as s17
on ag.AGE_CODE = s17.AGE_CODE
left outer join (select SUM(TARGET_POP) as s, AGE_CODE from SLEEP_TIME_DTL where TIME_CODE = 180 GROUP BY TIME_CODE, AGE_CODE) as s18
on ag.AGE_CODE = s18.AGE_CODE