Pregunta de entrevista de Cognizant

ranking using SQL with and without window function