I'm trying to get data on the number of problems we have open on a given day/month whatever. but I"m completely stumped I know how to query the db if the problem happened during this month or last month, but what I really want is the total number of problems divided out by the months they happened.

e.g.

TableName: problem
id start_date
1 01/12/03
2 01/08/03
3 02/12/03
4 01/04/04

QueryName: perfectQuery
1/03 2
2/03 1
1/04 1
Ideas?

Nevermind I think I figured it out. I don't know if it will span years though.