SELECT
    age.age_code AS 年齢コード
    , age.age_name AS 年齢階層名
    , SUM(dtl.sp_time_5) AS "5時間未満"
    , SUM(dtl.sp_time_6) AS "5時間以上6時間未満"
    , SUM(dtl.sp_time_7) AS "6時間以上7時間未満"
    , SUM(dtl.sp_time_8) AS "7時間以上8時間未満"
    , SUM(dtl.sp_time_9) AS "8時間以上9時間未満"
    , SUM(dtl.sp_time_9over) AS "9時間以上"
FROM
    sleep_time_dtl dtl
    INNER JOIN
        age_grp age
        ON dtl.age_code = age.age_code
WHERE
    dtl.pf_code IN ('01000', '02000', '03000', '04000', '07000')
GROUP BY
    1, 2
ORDER BY 
    1