SELECT AGE_GRP.AGE_NAME AS "年齢階層",
(
select COALESCE(SUM(COALESCE(a_grp.TARGET_POP, 0)), 0)
from SLEEP_TIME_DTL AS a_grp 
where AGE_GRP.AGE_CODE = a_grp.AGE_CODE and  a_grp.TIME_CODE = 120 and 
a_grp.TARGET_POP NOT NULL) 
AS "5時間未満",
(
select COALESCE(SUM(COALESCE(c_grp.TARGET_POP, 0)), 0)
from SLEEP_TIME_DTL AS c_grp 
where AGE_GRP.AGE_CODE = c_grp.AGE_CODE and c_grp.TIME_CODE = 130 and 
c_grp.TARGET_POP NOT NULL) AS "5時間以上6時間未満",
(select COALESCE(SUM(COALESCE(d_grp.TARGET_POP, 0)), 0) 
from SLEEP_TIME_DTL AS d_grp 
where AGE_GRP.AGE_CODE = d_grp.AGE_CODE and  d_grp.TIME_CODE = 140 and 
d_grp.TARGET_POP NOT NULL) AS "6時間以上7時間未満",
(select COALESCE(SUM(COALESCE(e_grp.TARGET_POP, 0)), 0) 
from SLEEP_TIME_DTL AS e_grp 
where AGE_GRP.AGE_CODE = e_grp.AGE_CODE and e_grp.TIME_CODE = 150 and 
e_grp.TARGET_POP NOT NULL) AS "7時間以上8時間未満",
(select COALESCE(SUM(COALESCE(f_grp.TARGET_POP, 0)), 0) 
from SLEEP_TIME_DTL AS f_grp where AGE_GRP.AGE_CODE = f_grp.AGE_CODE and 
f_grp.TIME_CODE = 160 and f_grp.TARGET_POP NOT NULL) AS "8時間以上9時間未満",
(select COALESCE(SUM(COALESCE(g_grp.TARGET_POP, 0)), 0) 
from SLEEP_TIME_DTL AS g_grp where AGE_GRP.AGE_CODE = g_grp.AGE_CODE and 
g_grp.TIME_CODE = 170 and g_grp.TARGET_POP NOT NULL) AS "9時間以上",
(select COALESCE(SUM(COALESCE(h_grp.TARGET_POP, 0)), 0) 
from SLEEP_TIME_DTL AS h_grp where AGE_GRP.AGE_CODE = h_grp.AGE_CODE 
and  h_grp.TIME_CODE = 180 and h_grp.TARGET_POP NOT NULL) AS "不詳"
FROM AGE_GRP
WHERE AGE_GRP.AGE_CODE >= 2
AND AGE_GRP.AGE_CODE <= 6