Cognizant interview question

ranking using SQL with and without window function