select date_format(datepurch,'%Y-%m') as MONTH, count(*), sum(cost)
from cd
group by MONTH
> Date: Fri, 12 Apr 2002 14:57:55 -0400
> From: Jesse Sheidlower <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Newbie "GROUP"-type question
>
I'm relatively new to the construction of complex queries,
and I'm trying to figure one out that I'm sure is common;
I wasn't able to find anything especially helpful in the docs.
Suppose I have the canonical database of CDs, with one table,
which includes fields for title, cost, and date_purcha