select
    AG.AGE_NAME as 年齢階層
    , STD_5.TTP as '5時間未満'
    , STD_56.TTP as '5時間以上6時間未満'
    , STD_67.TTP as '6時間以上7時間未満'
    , STD_78.TTP as '7時間以上8時間未満'
    , STD_89.TTP as '8時間以上9時間未満'
    , STD_9.TTP as '9時間以上'
    , STD_X.TTP as '不詳'
from
    AGE_GRP as AG
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 120 group by 1) as STD_5 on STD_5.AGE_CODE = AG.AGE_CODE
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 130 group by 1) as STD_56 on STD_56.AGE_CODE = AG.AGE_CODE
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 140 group by 1) as STD_67 on STD_67.AGE_CODE = AG.AGE_CODE
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 150 group by 1) as STD_78 on STD_78.AGE_CODE = AG.AGE_CODE
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 160 group by 1) as STD_89 on STD_89.AGE_CODE = AG.AGE_CODE
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 170 group by 1) as STD_9 on STD_9.AGE_CODE = AG.AGE_CODE
join (select AGE_CODE, sum(TARGET_POP) as TTP from SLEEP_TIME_DTL where TIME_CODE = 180 group by 1) as STD_X on STD_X.AGE_CODE = AG.AGE_CODE
order by AG.AGE_CODE