README.md

Using gitqlite, query for percentage of commit count by author (in this case in facebook/react). Limit to top 25, include a "chart"

query.sql

WITH total_commits(total) AS (
    SELECT count(*) AS total FROM commits
)
SELECT
    author_name,
    round(count(*)*100.0 / (SELECT total FROM total_commits), 2) AS percentage,
    printf('%.' || (CAST (round(count(*)*100.0 / (SELECT total FROM total_commits)) AS INT) + 1) || 'c', '*') AS commits
FROM commits GROUP BY author_name
ORDER BY percentage DESC
LIMIT 25

sample-output

cat query.sql | gitqlite --repo https://github.com/facebook/react
+---------------------+------------+----------------+
|     AUTHOR NAME     | PERCENTAGE |    COMMITS     |
+---------------------+------------+----------------+
| Paul O’Shannessy    |      13.04 | ************** |
| Dan Abramov         |       10.7 | ************   |
| Brian Vaughn        |      10.41 | ***********    |
| Ben Alpert          |       9.06 | **********     |
| Andrew Clark        |       5.72 | *******        |
| Sebastian Markbåge  |       3.51 | *****          |
| Jim                 |       3.25 | ****           |
| Dominic Gannaway    |       3.06 | ****           |
| Sebastian Markbage  |       2.78 | ****           |
| Cheng Lou           |       1.66 | ***            |
| Pete Hunt           |       1.42 | **             |
| Christopher Chedeau |       1.24 | **             |
| petehunt            |       1.06 | **             |
| Ben Newman          |       1.05 | **             |
| Thomas Aylott       |       0.86 | **             |
| CommitSyncScript    |       0.73 | **             |
| Nicolas Gallagher   |       0.69 | **             |
| Nathan Hunzaker     |       0.64 | **             |
| Brandon Dail        |       0.58 | **             |
| Andreas Svensson    |       0.53 | **             |
| Flarnie Marchan     |       0.51 | **             |
| Toru Kobayashi      |       0.47 | *              |
| Sophie Alpert       |       0.45 | *              |
| Dan                 |       0.41 | *              |
| Timothy Yung        |       0.37 | *              |
+---------------------+------------+----------------+