Image Billing

select case
when month(a.CreatedOn)  =1 then 'January'
when month(a.CreatedOn)  =2 then 'February'
when month(a.CreatedOn)  =3 then 'March'
when month(a.CreatedOn)  =4 then 'April'
when month(a.CreatedOn)  =5 then 'May'
when month(a.CreatedOn)  =6 then 'June'
when month(a.CreatedOn)  =7 then 'July'
when month(a.CreatedOn)  =8 then 'August'
when month(a.CreatedOn)  =9 then 'September'
when month(a.CreatedOn)  =10 then 'October'
when month(a.CreatedOn)  =11 then 'November'
else 'December'end as Months,b.Username,b.RoleName,c.SubClientName,b.clientname,C.Name as OutleltName,
COUNT(DISTINCT a.SessionUid) AS Session_count,SUM (a.ImageCount) AS Image_count
FROM AssetPurity a
full outer Join vwSecurity_UserList b on a.CreatedByUserId = b.UserId
full outer join vwLocationList C on c.LocationId = a.LocationId
WHERE 
    a.ClientId = '408'
and cast(a.CreatedOn as date) >= '2025-04-01' and cast(a.CreatedOn as date) <'2025-05-01' and a.StatusId = '13'  --and a.IsDeleted=0
group by month(a.CreatedOn),b.Username,b.RoleName,c.SubClientName,b.clientname,C.Name         
ORDER BY month(a.CreatedOn) asc,b.Username asc

--------------------------------------------------