[zuzuu]

select id,durum,count(*) as sayi from tablom
group by id,durum