Query Result
Loading...Loading chart...
1SELECT repository, SUM(added) + SUM(deleted) AS changes, SUM(commits) AS commits, (SUM(added)+SUM(deleted))/SUM(commits) AS avg_commit_size
2FROM @jsoares.sandbox.github_stats_csv
3WHERE repository IN ('dns', 'devops', 'blt', 'blt-frontend', 'datasets-tooling')
4GROUP BY repository
5ORDER BY 4 ASC