That would be awesome. I did one analysis, but I’ll be very happy to see different analysis from different people. The alternatives are endless, we only need more hands.
For example, what else did the starrers of ‘oblac/jodd’ star in 2016?
SELECT repo, COUNT(*) c FROM (
SELECT actor.login, ARRAY_AGG(DISTINCT repo.name) repos
WHERE type="WatchEvent" GROUP BY 1
HAVING ARRAY_LENGTH(repos) BETWEEN 3 AND 30000 # if you star too much, your vote doesn't count
AND 'oblac/jodd' IN UNNEST(repos)
), UNNEST(repos) repo
GROUP BY 1 ORDER BY 2 DESC