Find the house that has won max no of battles for each region | Data Engineering Interview | fractal

[@prajju8114]

i think we should use row_number not dense_rank, please clarify

[@NiteeshKumarPinjala]

At final , How come region The house has same rank? we have used dense rank right, it shouldn't give us the same rank. Please clarify.

[@atharvjoshi9959]

voice is echoing. pls rectify it