SELECT s3.AGE_CODE as '年齢コード', 
s3.AGE_NAME as '年齢階層名', 
s3.SP_TIME_5 as'5時間未満',
s3.SP_TIME_6 as'5時間以上6時間未満',
s3.SP_TIME_7 as'6時間以上7時間未満',
s3.SP_TIME_8 as'7時間以上8時間未満',
s3.SP_TIME_9 as'8時間以上9時間未満',
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