ISN Software Interview Question

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