If you notice the ranking is not consecutive with the use of the RANK function; that is because the RANK function ranks records of the result-set sequentially starting from 1. When it finds a tie it assigns the same rank to the all the records in the tie, but still keeps incrementing the record counter so the next record will get a new rank which would be (previous rank + no of records in the current tie + 1) .
implausible meaning, definition, what is implausible: difficult to believe and therefore unlik...: Learn more.
Definition of discrepancy. plural. discrepancies. 1 : the quality or state of disagreeing or being at variance. 2 : an instance of disagreeing or being at variance.