select * from
(
select a."AGE_NAME" as "年齢階層",
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 120 and c."AGE_CODE" = a."AGE_CODE") as "5時間未満" ,
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 130 and c."AGE_CODE" = a."AGE_CODE") as "5時間以上6時間未満",
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 140 and c."AGE_CODE" = a."AGE_CODE") as "6時間以上7時間未満",
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 150 and c."AGE_CODE" = a."AGE_CODE") as "7時間以上8時間未満",
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 160 and c."AGE_CODE" = a."AGE_CODE") as "8時間以上9時間未満",
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 170 and c."AGE_CODE" = a."AGE_CODE") as "9時間以上",
(select sum(c."TARGET_POP") from "SLEEP_TIME_DTL" as c where c."TIME_CODE" = 180 and c."AGE_CODE" = a."AGE_CODE")  as "不詳"
from "AGE_GRP" as a
) as tmp
where tmp."5時間未満" is not null
and tmp."5時間以上6時間未満" is not null
and tmp."6時間以上7時間未満" is not null
and tmp."5時間以上6時間未満" is not null
and tmp."7時間以上8時間未満" is not null
and tmp."8時間以上9時間未満" is not null
and tmp."9時間以上" is not null
and tmp."不詳" is not null