Luis Cazares (7/16/2015)
I just made up some sample data including the columns mentioned in the query and an additional to group by so I can show you the different examples which would generate the results that you say can't happen. I guess the problem is that you're missing the part that these are separate CASE statements in different aggregate functions, so no need to think row-by-row.
Which requires adding the group by, which is fine, again just trying to see what their output goal is, not arguing that if there goal is to count 4s and 3s in a grouped set that it can't be done, but as presented the user will not get those types of results.