select
      AGE_CODE as "年齢コード"
    , AGE_NAME as "年齢階層名"
    , sum(SP_TIME_5) as "5時間未満"
    , sum(SP_TIME_6) as "5時間以上6時間未満"
    , sum(SP_TIME_7) as "6時間以上7時間未満 "
    , sum(SP_TIME_8) as "7時間以上8時間未満 "
    , sum(SP_TIME_9) as "8時間以上9時間未満 "
    , sum(SP_TIME_9OVER) as "9時間以上"
from
    (
    select
          a.PF_CODE
        , b.PF_NAME
        , a.AGE_CODE
        , c.AGE_NAME
        , a.SP_TIME_5
        , a.SP_TIME_6
        , a.SP_TIME_7
        , a.SP_TIME_8
        , a.SP_TIME_9
        , a.SP_TIME_9OVER
    from
        (
        select
              PF_CODE
            , AGE_CODE
            , SP_TIME_5
            , SP_TIME_6
            , SP_TIME_7
            , SP_TIME_8
            , SP_TIME_9
            , SP_TIME_9OVER
        from
            SLEEP_TIME_DTL
        ) a
        inner join
        (
        select
              PF_CODE
            , PF_NAME
        from
            PREFECTURE
        where
            PF_NAME in ("北海道","青森県","岩手県","宮城県","福島県")
        ) b
        using(PF_CODE)
        inner join
        (
        select
              AGE_CODE
            , AGE_NAME
        from
            AGE_GRP
        ) c
        using(AGE_CODE)
    )
group by AGE_CODE, AGE_NAME
order by AGE_CODE asc