SELECT S.AGE_CODE, AGE_NAME, SUM(S.SP_TIME_5), SUM(S.SP_TIME_6), SUM(S.SP_TIME_7), SUM(S.SP_TIME_8), SUM(S.SP_TIME_9), SUM(S.SP_TIME_9OVER)
FROM (SLEEP_TIME_DTL as S INNER JOIN PREFECTURE as P ON P.PF_CODE = S.PF_CODE)
INNER JOIN AGE_GRP as A ON S.AGE_CODE = A.AGE_CODE
WHERE PF_NAME in ('北海道','青森県','岩手県','宮城県','福島県')
GROUP BY S.AGE_CODE
ORDER BY S.AGE_CODE ASC;