A long time ago I stumbled upon Acha acha - a project to assign achievements to contributors based on the commit history in a Git repository. I figured it’ll be fun to reimplement it using only SQL. I wrote a custom Trino connector to read commits from a repository and then wrote a bunch of queries.
Check out the achievements in the Trino project: Trino Git Achievements | trino-git-achievements
Queries are available at GitHub - MiguelWeezardo/trino-git-achievements: GIT achievements for the Trino project