如何在分组依据中使用案例陈述列

As stated by the question, I'm trying to formulate a query that has a case statement in the column results, and then I want to include that column in the query's group by statement. To give a concrete example, here is all little of what my query looks like:As stated by the question, I'm trying to formul