Pregunta de entrevista de QuantZig

SQL queries - Dense_Rank, Rank, inner join ,case based situation