create table test(a varchar(7),b varchar(7),c char(10))

insert test

select '과일','바나나','2007-05-01' union all

select '과일','사과','2007-05-01' union all

select '유제품','우유','2007-05-01' union all

select '유제품','치즈','2007-05-02' union all

select '과일','바나나','2007-05-02'

------------------------------

select a,count(*),c from test group by a,c

/*

a                   c

------- ----------- ----------

과일     2           2007-05-01

유제품    1           2007-05-01

과일     1           2007-05-02

유제품    1           2007-05-02

(4개 행 적용됨)

*/

한줄 완벽하네요 -0- 감사합니다.