SELECT AGE_CODE 
       , AGE_NAME
       , SP_TIME_5
       , SP_TIME_6
       , SP_TIME_7
       , SP_TIME_8
       , SP_TIME_9
       , SP_TIME_9OVER

FROM SLEEP_TIME_DTL AS S

INNER JOIN AGE_GRP AS A
ON S.AGE_CODE = A.AGE_CODE
WHERE PF_NAME = 北海道 OR PF_NAME = 青森県 OR PF_NAME = 岩手県 OR PF_NAME = 宮城県 OR PF_NAME = 福島県

INNER JOIN PREFECTURE AS P
ON S.PF_CODE = P.PF_CODE

ORDER BY AGE_CODE;