• some solutions become simple and convenient since RANK function(NOW_NUMBER,RANK and DENSE_RANK).