SELECT
  A.AGE_CODE         AS "年齢コード"
, B.AGE_NAME         AS "年齢階層名"
, SUM(SP_TIME_5)     AS "5時間未満"
, SUM(SP_TIME_6)     AS "5時間以上6時間未満"
, SUM(SP_TIME_7)     AS "6時間以上7時間未満"
, SUM(SP_TIME_8)     AS "7時間以上8時間未満"
, SUM(SP_TIME_9)     AS "8時間以上9時間未満"
, SUM(SP_TIME_9OVER) AS "9時間以上"
FROM
  SLEEP_TIME_DTL A
  INNER JOIN AGE_GRP    B ON A.AGE_CODE = B.AGE_CODE
  INNER JOIN PREFECTURE C ON A.PF_CODE  = C.PF_CODE
WHERE
  C.PF_NAME IN (
    '北海道', '青森県', '岩手県', '宮城県', '福島県'
  )
GROUP BY
  A.AGE_CODE
, B.AGE_NAME
ORDER BY 1;