select
AGE_NAME as 年齢階層
,T120.TARGET_POP as "5時間未満"
,T130.TARGET_POP as "5時間以上6時間未満"
,T140.TARGET_POP as "6時間以上7時間未満"
,T150.TARGET_POP as "7時間以上8時間未満"
,T160.TARGET_POP as "8時間以上9時間未満"
,T170.TARGET_POP as "9時間以上"
,T180.TARGET_POP as 不詳
FROM AGE_GRP
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =120 group by AGE_CODE) T120
using(AGE_CODE)
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =130 group by AGE_CODE) T130
using(AGE_CODE)
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =140 group by AGE_CODE) T140
using(AGE_CODE)
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =150 group by AGE_CODE) T150
using(AGE_CODE)
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =160 group by AGE_CODE) T160
using(AGE_CODE)
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =170 group by AGE_CODE) T170
using(AGE_CODE)
inner join (select AGE_CODE ,sum(TARGET_POP) as TARGET_POP from SLEEP_TIME_DTL where TIME_CODE =180 group by AGE_CODE) T180
using(AGE_CODE)
order by AGE_CODE