did not know about it.

I will read it, thanks.

that is very interesting

I imagined that I had to do this as well but this Kata accepts your solution if you just leave the 'rand' column on the final result as well.

Hadouken!

Hadouken!!!

Hadouken!!!

How come I did not try that before?
By the way, is this really JS?

I don't think so. the group by conditions are different - there is no reusable logic here

I enjoyed the NULLIF inside COALESCE. Congrats!

Tests do not consider adding a ORDER BY in the query.
It was not asked, but having an unsorted result looks awful.

The code used razor leaf

It's super effective

or you can use charAt method like 'abcdef'.charAt(0) == 'a'

in real live requirements change. The effort of writting both is equivalent and looping an array with 3 elements is not a performance bottleneck so there is a point in doing a loop

this parseInt odd behavior was probably implemented in such way only because of this Kata