SELECT SL.AGE_CODE AS 年齢コード
       ,AG.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 AGE_GRP AS AG
   ON SL.AGE_CODE = AG.AGE_CODE
INNER JOIN PREFECTURE AS PF
   ON SL.PF_CODE = PF.PF_CODE
WHERE PF.PF_NAME = "北海道"
      OR PF.PF_NAME = "青森県"
      OR PF.PF_NAME = "岩手県"
      OR PF.PF_NAME = "宮城県"
      OR PF.PF_NAME = "福島県"
GROUP BY SL.AGE_CODE
         ,AG.AGE_NAME
ORDER BY SL.AGE_CODE