I am basically looking to replicate the order of values for a fantasy football draft, but applied to results from a sql server query. This is more or less the result I’m looking for:

I’m pretty sure this is a window function, but I don’t know what the exact arguments would be.