select 
	 Age.age_name AS 年齢階層
	,SUM(
		CASE Rel.time_code 
			WHEN 120 THEN 1
			ELSE 0
		END
	) AS '5時間未満'
	,SUM(
		CASE Rel.time_code 
			WHEN 130 THEN 1
			ELSE 0
		END
	) AS '5時間以上6時間未満'
	,SUM(
		CASE Rel.time_code 
			WHEN 140 THEN 1
			ELSE 0
		END
	) AS '6時間以上7時間未満'
	,SUM(
		CASE Rel.time_code 
			WHEN 150 THEN 1
			ELSE 0
		END
	) AS '7時間以上8時間未満'
	,SUM(
		CASE Rel.time_code 
			WHEN 160 THEN 1
			ELSE 0
		END
	) AS '8時間以上9時間未満'
	,SUM(
		CASE Rel.time_code 
			WHEN 170 THEN 1
			ELSE 0
		END
	) AS '9時間以上'
	,SUM(
		CASE Rel.time_code 
			WHEN 180 THEN 1
			ELSE 0
		END
	) AS '不詳'
from
	SLEEP_TIME_DTL Rel
INNER JOIN
	AGE_GRP Age
ON	
	Rel.age_code = Age.age_code
INNER JOIN
	SLEEP_TIME Sleep
ON
	Rel.TIME_CODE = Sleep.TIME_CODE
GROUP BY
	Age.age_name
ORDER BY
    Sleep.time_code
;