쿼리 방법은 여러가지 있지만 아래는 그중 한가지 방법입니다.

SELECT date

               , sum(case when room='C1' then cnt

                         else 0

                        end)  AS C1

                , sum(case when room='C2' then cnt

                           else 0

                          end) AS C2

from ( select date, room, count(1) cnt

           from total

           where room in ('c1','c2')

              and date between '20130401' and '20130405'

            group by date, room

)

group by date

 SELECT date

select MAX ( A.DATE ) 날짜
     , MAX ( COUNT(*) ) C1
     , MIN ( COUNT(*) ) C2 
  from TOTAL A
 where A.ROOM in ('C1', 'C2')
  and A.DATE between '20130401' and '20130405'
group by A.DATE
order by A.DATE
 

와 다들 감사합니다 ~~~~~~~~~~~~~~~~~~~~^^;

유용하게 잘 사용하겠습니다 ~~~~~~~~