select MONTH(b.TglEntry) as months, d.Customer, COUNT(b.HelpdeskID) as cases,
AVG (datediff(dd, b.TglEntry, b.FinishDate)) as [average days], a.Description
from HelpdeskStatId a
right join HelpDesk b on a.StatId = b.Status
right join Site c on b.Site = c.idSite
left join Customer d on b.idCustomer = d.idCustomer
group by MONTH(b.TglEntry), d.Customer, a.Description
order by MONTH(b.TglEntry)

Advertisement