SELECT
    d.age_code AS 年齢コード
,   g.age_name AS 年齢階層名
,   d.sp_time_5 AS `5時間未満`
,   d.sp_time_6 AS `5時間以上6時間未満`
,   d.sp_time_7 AS `6時間以上7時間未満`
,   d.sp_time_8 AS `7時間以上8時間未満`
,   d.sp_time_9 AS `8時間以上9時間未満`
,   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 ('北海道', '青森県', '岩手県', '宮城県', '福島県')
ORDER BY
    d.age_code
;