select
an as 年齢階層,
max(case when tn = '5時間未満' then su end) as '5時間未満',
max(case when tn = '5時間以上6時間未満' then su end) as '5時間以上6時間未満',
max(case when tn = '6時間以上7時間未満' then su end) as '6時間以上7時間未満',
max(case when tn = '7時間以上8時間未満' then su end) as '7時間以上8時間未満',
max(case when tn = '8時間以上9時間未満' then su end) as '8時間以上9時間未満',
max(case when tn = '9時間以上' then su end) as '9時間以上',
max(case when tn = '不詳' then su end) as '不詳'
from
(
select
c.AGE_NAME as an,
b.TIME_NAME as tn,
sum(a.TARGET_POP) as su
from
SLEEP_TIME_DTL as a
inner join
SLEEP_TIME as b
on
a.TIME_CODE
=
b.TIME_CODE
inner join
AGE_GRP as c
on
a.AGE_CODE
=
c.AGE_CODE
group by
a.TIME_CODE,
a.AGE_CODE
) as d
group by
an
order by
年齢階層
asc
;