In this article I'm going to explain the use of the analytic functions RANK, DENSE_RANK and ROW_NUMBER to rank the results of your query.
Crop diversification refers to the addition of new crops or cropping systems to agricultural production on a particular farm taking into account the different returns from value-added crops with complementary marketing opportunities. Major driving forces for crop diversification include: â¢ Increasing income on small farm holdings
Crop rotation is important because certain crops deplete nutrients  from the soil and overplanting these crops can make the soil unable  to support future crops. By rotatingâ¦ crops, this allows nutrients  to replenish in the soil naturally, minimizing the need for  artificial fertilizers.