Github Data Challenge Example2

github-ruby-create.sql

/* top 100 owners for Ruby by number of creates */
SELECT repository_owner, count(repository_owner) as creates
FROM [githubarchive:github.timeline]
WHERE type="CreateEvent"
    AND repository_language="Ruby"
    AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2012-05-01 00:00:00')
GROUP BY repository_owner
ORDER BY creates DESC
LIMIT 100