Skip to content

Instantly share code, notes, and snippets.

@matburt

matburt/gist:1313c7684688f4c7ebe330297809537b

Created September 19, 2016 12:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matburt/1313c7684688f4c7ebe330297809537b to your computer and use it in GitHub Desktop.
Save matburt/1313c7684688f4c7ebe330297809537b to your computer and use it in GitHub Desktop.
Download ZIP
Octoverse 2016 - Contributions - No Comments - All Ansible
Raw
gistfile1.sql
SELECT
COUNT(DISTINCT events.actor.id) AS events_actor_count
FROM (
SELECT
*
FROM TABLE_DATE_RANGE([githubarchive:day.],TIMESTAMP('2015-09-01'),TIMESTAMP('2016-08-31'))) AS events
WHERE
(events.repo.name = 'ansible/ansible'
or events.repo.name = 'ansible/ansible-modules-extras'
or events.repo.name = 'ansible/ansible-modules-core') AND
(events.type = 'PushEvent'
OR events.type = 'PullRequestEvent'
OR events.type = 'IssuesEvent')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment