SELECT
  s.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 s
  JOIN age_grp a ON s.age_code = a.age_code
  JOIN prefecture p ON s.pf_code = p.pf_code
WHERE
  p.pf_name IN ("北海道", "青森県", "岩手県", "宮城県", "福島県")
GROUP BY
  s.age_code
ORDER BY
  s.age_code;