Ranking entities

My kid is in a school with houses, each having points.

The school publish these on a website which I scrape using node-red into four entities.

Does anyone have any idea how I would rank these either in HA or NR?

The end goal is to have Alexa announce. “[House A] has N points and is in Nth place behind [House B]” etc when triggered.

I think you can use join and sort nodes for that. when triggered, you need to get current status of entites, join the messages and finally sort them.