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