List of top contributors 🔝

[nelsonic]

Todo

• Write an SQL Query that lists the top contributors in the Org grouped by the number of contribs

[nelsonic]

contribs:

repositories:

users:

[nelsonic]

SELECT c.user_id, 
SUM(c.count), u.login
FROM contribs c
LEFT JOIN users u 
	ON u.id = c.user_id
GROUP BY c.user_id, u.login
ORDER By sum DESC

What impresses me about this result is that there are 382 Unique Contributors across the @dwyl projects. 🎉

[nelsonic]

Continue:

pgweb --host localhost --user postgres --db app_dev