QuantZig Interview Question

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