QuantZig interview question

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