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