SELECT tarih, COUNT(tarih) FROM siparisler 
where tarih BETWEEN '2008-11-01' and '2008-12-31'
GROUP BY tarih