select
    SL.AGE_CODE as "年齢コード"
    ,AGE.AGE_NAME as "	年齢階層名"
    ,sum(SL.SP_TIME_5) as "5時間未満"
    ,sum(SL.SP_TIME_6) as "5時間以上6時間未満"
    ,sum(SL.SP_TIME_7) as "6時間以上7時間未満"
    ,sum(SL.SP_TIME_8) as "7時間以上8時間未満"
    ,sum(SL.SP_TIME_9) as "8時間以上9時間未満"
    ,sum(SL.SP_TIME_9OVER) as "9時間以上"

from
    SLEEP_TIME_DTL as SL
        inner join PREFECTURE as PR
        on  SL.PF_CODE = PR.PF_CODE
        
        inner join AGE_GRP as AGE
        on SL.AGE_CODE = AGE.AGE_CODE
    
where
    PR.PF_NAME = "北海道"
    or PR.PF_NAME = "青森県"
    or PR.PF_NAME = "岩手県"
    or PR.PF_NAME = "宮城県"
    or PR.PF_NAME = "福島県"

group by
    SL.AGE_CODE

order by
    年齢コード asc
;