SELECT
  std.`AGE_CODE` AS '年齢コード',
  ag.`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 ag ON ag.AGE_CODE = std.AGE_CODE
    JOIN PREFECTURE as p ON p.PF_CODE = std.PF_CODE AND p.PF_CODE IN ('01000', '02000', '03000', '04000', '07000')
  GROUP BY std.AGE_CODE, ag.AGE_NAME
;