SELECT dtl.AGE_CODE as "年齢コード"
       ,grp.AGE_NAME as "年齢階層名"
       ,SUM( dtl.SP_TIME_5 ) as "5時間未満"
       ,SUM( dtl.SP_TIME_6 ) as "5時間以上6時間未満"
       ,SUM( dtl.SP_TIME_7 ) as "6時間以上7時間未満"
       ,SUM( dtl.SP_TIME_8 ) as "7時間以上8時間未満"
       ,SUM( dtl.SP_TIME_9 ) as "8時間以上9時間未満"
       ,SUM( dtl.SP_TIME_9OVER ) as "9時間以上"
FROM SLEEP_TIME_DTL as dtl
    INNER JOIN AGE_GRP as grp
        ON dtl.AGE_CODE = grp.AGE_CODE
    LEFT JOIN PREFECTURE as pref
        ON dtl.PF_CODE = pref.PF_CODE
WHERE pref.PF_NAME IN ("北海道", "青森県", "岩手県", "宮城県", "福島県")
GROUP BY grp.AGE_CODE
ORDER BY grp.AGE_CODE