wbt

SELECT actor,
LOG10(COUNT(actor)) LogCount,
LOG10(AVG(LENGTH(payload_commit_msg))) LogCommentSizeMean
FROM [githubarchive:github.timeline]
WHERE repository_private='false'
AND type ='PushEvent'
GROUP BY actor
LIMIT 16000;

wbt

SELECT TYPE, COUNT(TYPE) FROM [githubarchive:github.timeline] GROUP BY TYPE;