使用group by返回零并在mysql中计数

I am counting the number of distinct customers and grouping it by another column .I would like the result to return zeros if no customers are found in the group. With the following code, I don't get zeros in my results. Can someone please help?I am counting the number of distinct customers