Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo

patrickdevivo/commits_by_email_domain.sql

Created February 14, 2021 19:20
Show Gist options
  • Save patrickdevivo/3514f0e0fa175f2106b655fec0348815 to your computer and use it in GitHub Desktop.
Save patrickdevivo/3514f0e0fa175f2106b655fec0348815 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
commits_by_email_domain.sql
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