Orders by items sold

SELECT OrderProducts.ProductId, OrderProducts.Sku, OrderProducts.Name, COUNT(OrderProducts.OrderId) AS Orders, SUM(OrderProducts.Quantity) AS "Unit Sold", SUM(OrderProducts.TotalIncTax) AS Revenue
  FROM OrderProducts
LEFT OUTER JOIN Orders AS OrderProducts_Orders ON OrderProducts.OrderId = OrderProducts_Orders.id
WHERE (OrderProducts_Orders.Status != 'Cancelled' AND OrderProducts_Orders.Status != 'Refunded' AND date(date(OrderProducts_Orders.DateCreated), 'start of month') = date('now', 'localtime', 'start of month'))
GROUP BY OrderProducts.ProductId, OrderProducts.Sku, OrderProducts.Name
ORDER BY OrderProducts.Name
  

Open Query