I knew the moment I completed my code, that someone would have a one-liner posted.
Idk how usable this one-liner is, but it works so G-freaking-G man. Hats off!

And what's the issue here? The fact that you assigned names to columns while ignoring their actual order in the query output?

I had this issue too, it was very frustrating.

Hi. Your AS clause is incorrect. The columns good, bad and ok display NUMERIC values, and hence the Type should be int/bigint as below. Also, due to the poorly designed nature of the question, the order of the AS clause should be NAME, BAD, GOOD, OK (I failed a testcase because of the order...)

AS ct(name text, bad bigint, good bigint, ok bigint)

I just found out that it's because of the order of the grading in the AS CLAUSE.

So I just forfeit a question, to find out that I lost points for naming it in the correct manner as stated in the question? WTH!!!

I want these points back dammit WTH! >.>