MCG Health interview question

Rand function in sql windows functions