select ag.AGE_NAME as "年齢階層"
      ,tmp1.sum_TARGET_POP1 as "5時間未満"
      ,tmp2.sum_TARGET_POP2 as "5時間以上6時間未満"
      ,tmp3.sum_TARGET_POP3 as "6時間以上7時間未満"
      ,tmp4.sum_TARGET_POP4 as "7時間以上8時間未満"
      ,tmp5.sum_TARGET_POP5 as "8時間以上9時間未満"
      ,tmp6.sum_TARGET_POP6 as "9時間以上"
      ,tmp7.sum_TARGET_POP7 as "不詳"
from AGE_GRP ag,
( select AGE_CODE,SUM(TARGET_POP) sum_TARGET_POP1
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 120
  group by AGE_CODE ) tmp1,
( select AGE_CODE, SUM(TARGET_POP) sum_TARGET_POP2
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 130
  group by AGE_CODE ) tmp2,
( select AGE_CODE, SUM(TARGET_POP) sum_TARGET_POP3
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 140
  group by AGE_CODE ) tmp3,
( select AGE_CODE, SUM(TARGET_POP) sum_TARGET_POP4
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 150
  group by AGE_CODE ) tmp4,
( select AGE_CODE, SUM(TARGET_POP) sum_TARGET_POP5
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 160
  group by AGE_CODE ) tmp5,
( select AGE_CODE, SUM(TARGET_POP) sum_TARGET_POP6
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 170
  group by AGE_CODE ) tmp6,
( select AGE_CODE, (TARGET_POP) sum_TARGET_POP7
  from   SLEEP_TIME_DTL
  where  TIME_CODE = 180
  group by AGE_CODE ) tmp7
where ag.AGE_CODE = tmp1.AGE_CODE
and   ag.AGE_CODE = tmp2.AGE_CODE
and   ag.AGE_CODE = tmp3.AGE_CODE
and   ag.AGE_CODE = tmp4.AGE_CODE
and   ag.AGE_CODE = tmp5.AGE_CODE
and   ag.AGE_CODE = tmp6.AGE_CODE
and   ag.AGE_CODE = tmp7.AGE_CODE
order by ag.AGE_CODE
;