Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT
count(*),
substr(author_email, instr(author_email, '@')+1) AS email_domain -- https://sqlite.org/lang_corefunc.html
FROM commits
WHERE parent_count < 2 -- ignore merge commits
GROUP BY email_domain
ORDER BY count(*) DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment