I'm a DBA and don't get much chance to write much in the way of SQL to get at the data so, here goes...

I have a date column, and order number column, a customer id...1 row for each order.

I want, basically, to group by date (Year - then Month within year)
And within this grouping show the individual customers and the number of orders each customer issued each month.

Sounds simple but I'm having trouble grouping.

Using 8.1.5.