Multi-stream: dense rank over joined rows, ties sharing a place

Ranking is two passes: the distinct scores give the rank scale, the rows then read their place off it. Two players on the same score share a rank and the next one is not skipped - which is what dense rank means.

Full code & output

This topic is available to signed-in members.