Description
To get Image count per Month for which ever client
Query :
To get Image count per Month for which ever client
Query :
SELECT
FORMAT(a.CreatedOn, 'yyyy-MM') AS Month,
SUM(a.ImageCount) AS TotalImageCount
FROM
vwAssetPurityList a
WHERE
a.ClientId = '213'
AND a.Country = 'Canada'
AND a.CreatedOn >= '2024-01-01'
AND a.CreatedOn <= '2024-12-31'
GROUP BY
FORMAT(a.CreatedOn, 'yyyy-MM')
ORDER BY
Month;
--------------------------------------------------