I attended Effective SQL reading session.
You can use range conditions like: min <= value and value <= max in join clause.
It's seems to useful in case that you would like to put ranks in clear ranges.
In the case, you need to prepare a tally table that represents the ranges.