DB Query: number of photos per month by EXIF date?

Hi
I'm trying to graph how many photos I take per month, and I'm having a hard time understanding Gallery's database. I'm looking to do something like this:

SELECT *, COUNT( * ) AS `count`
FROM `gallery2`.`tablename` WHERE 1
GROUP BY `month`
ORDER BY `date`
LIMIT 0,12

Obviously gallery2's database is much more complex than the above... I can probably get to it if someone could post an SQL statement that would get me a single image along with it's EXIF date...

Thanks in advance!
dbc