Skip to content

Instantly share code, notes, and snippets.

@dankohn dankohn/issues.sql
Last active Feb 26, 2017

Embed
What would you like to do?
SELECT
repo.name,
ROUND(COUNT(*)/EXACT_COUNT_DISTINCT(actor.login),2) comments_per_author,
EXACT_COUNT_DISTINCT(actor.login ) authors,
COUNT(*) comments
FROM
[githubarchive:year.2016]
WHERE
type IN ('IssueCommentEvent')
AND actor.login NOT IN (
SELECT
actor.login
FROM (
SELECT
actor.login,
COUNT(*) c
FROM
[githubarchive:year.2016]
WHERE
type IN ('IssueCommentEvent')
GROUP BY
1
HAVING
c>1000
ORDER BY
2 DESC ))
GROUP BY
1
HAVING
authors>400
ORDER BY
4 DESC
LIMIT
50
repo_name comments_per_author authors comments
kubernetes/kubernetes 13.88 3077 42703
docker/docker 4.41 7256 32004
facebook/react-native 5.32 5762 30644
PokemonGoF/PokemonGo-Bot 8.38 3056 25603
Microsoft/vscode 3.69 6684 24643
NixOS/nixpkgs 21.76 1088 23674
tensorflow/tensorflow 6.19 3799 23504
magento/magento2 7.48 3115 23311
angular/angular 4.89 4767 23298
apache/spark 25.52 815 20800
Automattic/wp-calypso 50.53 406 20517
dotnet/coreclr 32.22 629 20266
Ar1i/PokemonGo-Bot 7.55 2552 19273
dotnet/roslyn 14.39 1304 18767
dotnet/corefx 12.83 1376 17651
golang/go 7.96 2204 17536
nodejs/node 6.77 2576 17431
rust-lang/rust 10.7 1625 17382
joomla/joomla-cms 13.53 1262 17080
saltstack/salt 8.67 1971 17079
AHAAAAAAA/PokemonGo-Map 6.04 2812 16993
Microsoft/TypeScript 5.65 2980 16834
hashicorp/terraform 4.75 3339 15876
FreeCodeCamp/FreeCodeCamp 3.71 4088 15182
elastic/elasticsearch 6.61 2161 14286
CleverRaven/Cataclysm-DDA 29.09 488 14196
NECROBOTIO/NecroBot 4.75 2873 13659
rails/rails 5.55 2440 13533
ansible/ansible 3.7 3626 13409
JuliaLang/julia 17.06 782 13343
driftyco/ionic 3.55 3735 13274
XX-net/XX-Net 5.92 2187 12942
fastlane/fastlane 5.26 2446 12878
FortAwesome/Font-Awesome 1.48 8409 12453
npm/npm 2.17 5610 12146
atom/atom 2.7 4435 11996
owncloud/core 5.61 2135 11984
openshift/origin 22.72 523 11885
servo/servo 15.71 736 11561
meteor/meteor 4.55 2529 11516
angular/angular-cli 3.65 3145 11492
laravel/framework 3.94 2898 11431
TrinityCore/TrinityCore 19.1 590 11268
PokemonGoMap/PokemonGo-Map 7.54 1478 11144
syl20bnr/spacemacs 6.07 1813 10996
symfony/symfony 6.67 1618 10789
MarlinFirmware/Marlin 12.98 812 10538
fchollet/keras 5.08 2029 10315
finndev/PokeBuddy 8.49 1213 10293
godotengine/godot 13.05 779 10164
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.