Roughly 7 months ago, there was a challenge for the best query.
I don't recall the specifics, hence my interest in finding the details of the challenge.
I do recall that 'as ordinal' was used to pivot.
Can't seem to find any reference in the archives