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