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