SELECT
 SLP.AGE_CODE as 年齢コード
 ,AGE_NAME as 年齢階層名
 ,SUM(CASE WHEN SP_TIME_5 > 0 THEN SP_TIME_5 ELSE 0 END) as '5時間未満'
 ,SUM(CASE WHEN SP_TIME_6 > 0 THEN SP_TIME_6 ELSE 0 END) as '5時間以上6時間未満'
 ,SUM(CASE WHEN SP_TIME_7 > 0 THEN SP_TIME_7 ELSE 0 END) as '6時間以上7時間未満'
 ,SUM(CASE WHEN SP_TIME_8 > 0 THEN SP_TIME_8 ELSE 0 END) as '7時間以上8時間未満'
 ,SUM(CASE WHEN SP_TIME_9 > 0 THEN SP_TIME_9 ELSE 0 END) as '8時間以上9時間未満'
 ,SUM(CASE WHEN SP_TIME_9OVER > 0 THEN SP_TIME_9OVER ELSE 0 END) as '9時間以上'
FROM
 SLEEP_TIME_DTL SLP
JOIN
 AGE_GRP AGE
ON
 SLP.AGE_CODE = AGE.AGE_CODE
JOIN
 PREFECTURE PRE
ON
 SLP.PF_CODE = PRE.PF_CODE
WHERE
 PF_NAME = '北海道'
 or PF_NAME = '青森県'
 or PF_NAME = '岩手県'
 or PF_NAME = '宮城県'
 or PF_NAME = '福島県'
GROUP BY
 SLP.AGE_CODE
ORDER BY
 SLP.AGE_CODE ASC;