SELECT
  b.age_name AS "年齢階層",
  SUM(
    CASE
      a.time_code
      WHEN 120 THEN a.target_pop
      ELSE 0
    END
  ) AS "5時間未満",
  SUM(
    CASE
      a.time_code
      WHEN 130 THEN a.target_pop
      ELSE 0
    END
  ) AS "5時間以上6時間未満",
  SUM(
    CASE
      a.time_code
      WHEN 140 THEN a.target_pop
      ELSE 0
    END
  ) AS "6時間以上7時間未満",
  SUM(
    CASE
      a.time_code
      WHEN 150 THEN a.target_pop
      ELSE 0
    END
  ) AS "7時間以上8時間未満",
  SUM(
    CASE
      a.time_code
      WHEN 160 THEN a.target_pop
      ELSE 0
    END
  ) AS "8時間以上9時間未満",
  SUM(
    CASE
      a.time_code
      WHEN 170 THEN a.target_pop
      ELSE 0
    END
  ) AS "9時間以上",
  SUM(
    CASE
      a.time_code
      WHEN 180 THEN a.target_pop
      ELSE 0
    END
  ) AS "不詳"
FROM
  sleep_time_dtl a
  JOIN age_grp b ON a.age_code = b.age_code
  JOIN sleep_time c ON a.time_code = c.time_code
GROUP BY
  a.age_code
ORDER BY
  a.age_code;