I have a table with information about sold products, the customer, the date of the purchase and summary of sold units.
The result I am trying to get should be 4 rows where the 1st three are for January, February and March. The last row is for the products that weren't sold in these 3 months.
Here is the table. http://imageshack.us/a/img823/8731/fmlxv.jpg
The table columns are:
I would go with the following
SELECT SUM(totalprice), year(date), month(date) FROM sales GROUP BY year(date), month(date)