How should I perform a hashtag trend system query?

[vim]

Hello friends, I am trying to create a trending hashtag system. I have sorted out the hashtag issue, but I think I may encounter some problems with the trending queries. My goal is to create a table called "hashtag" where I will only assign points to hashtags. Let's say 4 hashtags are entered in a minute: 1. #asd 2. #asd 3. #hashtag 4. #location. Now, based on these points, #asd will receive +2 points but let's say #hashtag will receive +1 point. These points will decrease by -1 point every 10 minutes. How can I query this and should I build the trending system as I mentioned?