select
    AGE_NAME as "年齢階層",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 120) as "5時間未満",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 130) as "5時間以上6時間未満",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 140) as "6時間以上7時間未満",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 150) as "7時間以上8時間未満",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 160) as "8時間以上9時間未満",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 170) as "9時間以上",
    sum(TARGET_POP) filter(where SLEEP_TIME_DTL.TIME_CODE = 180) as "不詳"
from
    AGE_GRP,
    SLEEP_TIME,
    SLEEP_TIME_DTL
where
    AGE_GRP.AGE_CODE = SLEEP_TIME_DTL.AGE_CODE and
    SLEEP_TIME.TIME_CODE = SLEEP_TIME_DTL.TIME_CODE
group by
    SLEEP_TIME_DTL.AGE_CODE;