ISN Software interview question

Asked me a situation question where you need to use sql rank function