Have you considered an array aggregator using the Group by feature in the module? This can be placed after the search on your data store which will retrieve multiple bundles for each row. The array aggregator can create groups by the school_ID key and then you can do a sort on the resulting bundles by the view count in descending order generating the rank order by each group.
Every result (item/record) from a search module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module.
Yes, that is possible. You’ll need four modules:
Select Bundle Order Position for the “Rank”, but this “Bundle Order Position” is by school because we are iterating the school’s array. So each school will begin the rank (Bundle Order Position) with 1.
Is it really this easy? Haven’t thought of using bundle order position. Thank you very much! Sorry for the long wait for my answer but over the christmas days family and friends came first. All the best for you in 2024!
Yes, Make is really easy and fun to use when you have learned all the basics!
If you want to learn more about Make, you can read up in the Help Center. I also recommend doing the tutorials in the Make Academy, and learn advanced skills like how to make custom apps to any API in the Make Partner Training Portal - both have certificates for successful completion.
Hope you had a wonderful holiday season, and see you around!
Thank you very much! 
Sorry for the long wait for my answer but over the christmas days family and friends came first. 
All the best for you in 2024!