初学者Oracle SQL计数功能多列

I am going through a practice worksheet with questions and expected outputs. The last question is proving to be difficult for me to grasp. Can anyone help please.I am going through a practice worksheet with qu