참고하세여

select a1.cpart,

sum(a1.C12) h12, sum(a1.C13) h13, sum(a1.C14) h14, sum(a1.C15) h15, sum(a1.C16) h16, sum(a1.C17) h17

from

(

select

cpart as cpart,

case when left(ctime,2) = '12' then 1 else 0 end as C12,

case when left(ctime,2) = '13' then 1 else 0 end as C13,

case when left(ctime,2) = '14' then 1 else 0 end as C14,

case when left(ctime,2) = '15' then 1 else 0 end as C15,

case when left(ctime,2) = '16' then 1 else 0 end as C16,

case when left(ctime,2) = '17' then 1 else 0 end as C17

from ctest

) a1

group by cpart