Your table structures are needed in a question like this…
The query would be something like this:
<pre>SELECT DATEPART(mm,purchase_date),COUNT(*)
FROM your_table
WHERE purchase_date between ‘2008-01-01’ and ‘2008-12-31’
GROUP BY DATEPART(mm,purchase_date);</pre>
Discuss This Question: