i want to plot a chart showing the monthly sales divided by each product type every month and categorised by year.
SELECT
year(invoice_date),
month(invoice_date),
SUM(price) AS amount,
product
FROM invoice
GROUP BY year(invoice_date), month(invoice_date), product
initially, i could not do it. pls advise how to.