SELECT
    d.age_code AS 年齢コード
,   g.age_name AS 年齢階層名
,   SUM(d.sp_time_5) AS `5時間未満`
,   SUM(d.sp_time_6) AS `5時間以上6時間未満`
,   SUM(d.sp_time_7) AS `6時間以上7時間未満`
,   SUM(d.sp_time_8) AS `7時間以上8時間未満`
,   SUM(d.sp_time_9) AS `8時間以上9時間未満`
,   SUM(d.sp_time_9over) AS `9時間以上`
FROM
    sleep_time_dtl AS d
    INNER JOIN
        prefecture AS p
        ON d.pf_code = p.pf_code
    INNER JOIN
        age_grp AS g
        ON d.age_code = g.age_code
WHERE
    p.pf_name IN ('北海道', '青森県', '岩手県', '宮城県', '福島県')
GROUP BY
    g.age_name
ORDER BY
    d.age_code
;