Skip to content

Instantly share code, notes, and snippets.

@ewhauser

ewhauser/angular_top_issues.sql

Created October 12, 2019 21:16
Show Gist options
  • Save ewhauser/a3b72e593f18d3d265a17e7f89340c07 to your computer and use it in GitHub Desktop.
Save ewhauser/a3b72e593f18d3d265a17e7f89340c07 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
angular_top_issues.sql
SELECT repo.name, JSON_EXTRACT(payload, '$.issue.number') as issue_id, COUNT(*) as count, JSON_EXTRACT(payload, '$.issue.title') as title
FROM `githubarchive.month.*`
WHERE type = 'IssueCommentEvent'
and repo.name = 'angular/angular'
and (_TABLE_SUFFIX like '2019%' or _TABLE_SUFFIX like '2018%' or _TABLE_SUFFIX like '2017%')
GROUP BY repo.name, issue_id, title
ORDER BY count desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment