This is something simple… but I use it a lot
####Template
[Items Vendidos:3, 1]
>Item|Cant
@@ItemsVendidos
[Items Bonificados:3, 1]
>Item|Cant
@@ItemsBonificados
[Items Cancelados:3, 1]
>Item|Cant
@@ItemsCancelados
####@@ItemsVendidos (SOLD ITEMS)
SELECT [MenuItemName],CONVERT(INT,SUM([Quantity])) as Cantidad
FROM [Orders]
WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND DecreaseInventory = 1 AND CalculatePrice <> 0
GROUP BY [MenuItemName]
ORDER BY Cantidad DESC
####@@ItemsBonificados (GIFTED ITEMS)
SELECT [MenuItemName],CONVERT(INT,SUM([Quantity])) as Cantidad
FROM [Orders]
WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND CalculatePrice = 0 AND DecreaseInventory <> 0
GROUP BY [MenuItemName]
ORDER BY Cantidad DESC
####@@ItemsCancelados (CANCELED ITEMS)
SELECT [MenuItemName],CONVERT(INT,SUM([Quantity])) as Cantidad
FROM [Orders]
WHERE [CreatedDateTime] > '{Start}' AND [CreatedDateTime] < '{End}' AND DecreaseInventory = 0
GROUP BY [MenuItemName]
ORDER BY Cantidad DESC