select
    AGE_GRP.AGE_NAME as "年齢階層",
    sum(dtl_120.TARGET_POP) as "5時間未満",
    sum(dtl_130.TARGET_POP) as "5時間以上6時間未満",
    sum(dtl_140.TARGET_POP) as "6時間以上7時間未満",
    sum(dtl_150.TARGET_POP) as "7時間以上8時間未満",
    sum(dtl_160.TARGET_POP) as "8時間以上9時間未満",
    sum(dtl_170.TARGET_POP) as "9時間以上",
    sum(dtl_180.TARGET_POP) as "不詳"
from
    AGE_GRP
    join SLEEP_TIME_DTL as dtl_120 on AGE_GRP.AGE_CODE = dtl_120.AGE_CODE
    and dtl_120.TIME_CODE = 120
    join SLEEP_TIME_DTL as dtl_130 on AGE_GRP.AGE_CODE = dtl_130.AGE_CODE
    and dtl_130.TIME_CODE = 130
    join SLEEP_TIME_DTL as dtl_140 on AGE_GRP.AGE_CODE = dtl_140.AGE_CODE
    and dtl_140.TIME_CODE = 140
    join SLEEP_TIME_DTL as dtl_150 on AGE_GRP.AGE_CODE = dtl_150.AGE_CODE
    and dtl_150.TIME_CODE = 150
    join SLEEP_TIME_DTL as dtl_160 on AGE_GRP.AGE_CODE = dtl_160.AGE_CODE
    and dtl_160.TIME_CODE = 160
    join SLEEP_TIME_DTL as dtl_170 on AGE_GRP.AGE_CODE = dtl_170.AGE_CODE
    and dtl_170.TIME_CODE = 170
    join SLEEP_TIME_DTL as dtl_180 on AGE_GRP.AGE_CODE = dtl_180.AGE_CODE
    and dtl_180.TIME_CODE = 180
group by
    AGE_GRP.AGE_CODE
order by
    AGE_GRP.AGE_CODE;