SELECT a.AGE_CODE as 年齢コード, a.AGE_NAME as 年齢階層名 , SUM(s.SP_TIME_5) as `5時間未満`, SUM(s.SP_TIME_6) as `5時間以上6時間未満`, SUM(s.SP_TIME_7) as `6時間以上7時間未満`, SUM(s.SP_TIME_8) as `7時間以上8時間未満`, SUM(s.SP_TIME_9) as `8時間以上9時間未満`, SUM(s.SP_TIME_9OVER) as `9時間以上`
FROM
  SLEEP_TIME_DTL as s, 
  (SELECT PF_CODE as codes FROM PREFECTURE WHERE PF_NAME in ("北海道","青森県","岩手県","宮城県","福島県")) as p,
  AGE_GRP as a
WHERE s.PF_CODE = p.codes AND a.AGE_CODE = s.AGE_CODE
GROUP BY s.AGE_CODE
ORDER BY s.AGE_CODE ASC