SQL "Group By" question

        I have a table called XYZ that has a column called date_open (which naturally has the date in which the entry was entered into the table).

I would like to create some sort of report/group by sql statement that will return : July 10, August 23 In other words, a count will be done on each month and will see how many calls were entered into the table. How would this be done? I've tried thinking about the between, but couldn;t figure how to show each month and its number of calls.

Thanks for your help,
Sean Received on Tue Aug 25 1998 - 17:59:44 CDT