Hey nice people! Did anyone ever created sql function for getting the trending posts on feed in last say one week?

This is application specific, and would require you to keep track of certain metrics (upvotes, comments, visits, etc). Before anyone could give a potential solution, we'd need to know what metrics you consider to indicate a post is 'trending'

Only likes and comments would be something we can track for now.