The description is forces you to use Distinct, but its wrong descigion.
Everyone literally hates this kata, but i found very interesting moment with explicit type casts.
It could be the pain in the ass, if you dont know, how deal with it on real database.
This is a bad kata...promoting bad practice
One small complaint: as a general rule of readability, you probably shouldn't use the same name for an input table and an output column, if only for the sake of absolute clarity.
In agreement with everyone here. This KATA is a total waste of time. AVOID!
Seems the sample tests want results ordered by id as said in instructions, but the attempt test wants results ordered by stock?
the sample tests want it ordered by id but the attempt test wants it ordered by stock