I'm in a database management class at college and I'm on my final question but I'm having some trouble.

The problem is:
How many films were rented each month during 2005?

This is on a pre-made database for a film rental store.
I can get SQL to print out the dates and how many movies were rented each day. But how do I group those dates by month?
I.E. Instead of getting


I want it to appear like this


How can I group dates like that?

My current SQL query.


rent_date in the table is the only information I can use as far as Dates go and they are listed by month/day/year.
I counted rent_date because the date is repeated in the table for every time a movie was rented.

I would prefer to display '5' as May and '6' as June but its not required.

(This may be easy for some of you but I'm fairly new to databases so bear with me)