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!

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! >.>