I want a query on the SalesInvoices table with the following characteristics;
1. Only include data from 2012
2. Use "group by" to produce the following format;
This should be fairly easy. However, can it be done in a SINGLE query. I find I need 2 queries.