select
  AG.AGE_NAME as `年齢階層`,
  TOTAL(IIF(TIME_CODE = 120, TARGET_POP, 0)) as `5時間未満`,
  TOTAL(IIF(TIME_CODE = 130, TARGET_POP, 0)) as `5時間以上6時間未満`,
  TOTAL(IIF(TIME_CODE = 140, TARGET_POP, 0)) as `6時間以上7時間未満`,
  TOTAL(IIF(TIME_CODE = 150, TARGET_POP, 0)) as `7時間以上8時間未満`,
  TOTAL(IIF(TIME_CODE = 160, TARGET_POP, 0)) as `8時間以上9時間未満`,
  TOTAL(IIF(TIME_CODE = 170, TARGET_POP, 0)) as `9時間以上`,
  TOTAL(IIF(TIME_CODE = 180, TARGET_POP, 0)) as `不詳`
from
  SLEEP_TIME_DTL as SD
  left join AGE_GRP as AG
  on SD.AGE_CODE = AG.AGE_CODE
group by
  SD.AGE_CODE
;