使用PHP和mysql多个有条件地GROUP BY和COUNT

First I'm sorry for my bad English and sorry for not providing the code that because I'm using my phone and my code is on my office PC. I have been searching on Google and trying to use First I'm sorry for my bad English and sorry fo