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 ta…