mysql查询组并显示可能的值

I'm looking for an awser, but can't find it on internet (maby because I don't know the correct term). I'm in search of a query that groups my values and also shows zero's for predefined values.I'm looking for an awser, but can't find it on