BQuery.md

Top 10 javascript developer in HK rated by activities

SELECT actor_attributes_email, count(*) as cnt
FROM [githubarchive:github.timeline]
where actor_attributes_location like "%Hong%" and repository_language = "JavaScript"
group by actor_attributes_email
order by cnt desc
LIMIT 10;

Rank popularity of languages since 2011

SELECT count(*) as cnt,repository_language from (TABLE_QUERY(githubarchive:year,'table_id CONTAINS "201"'))
group by repository_language
order by cnt desc
LIMIT 100

Who's busy now? (change the date to today)

SELECT count(*) as cnt, actor.login FROM [githubarchive:day.events_20150821]
group by actor.login
order by cnt desc
LIMIT 1000

1. Top 10 javascript developer in HK rated by activities
   Can get the github username as well?
   or link. i can click on that user to check his profile

for 2. i will change to 2014 only, and can show the % , so that javascript contains 40%

for 3, Is teddychan most use github?

SELECT count(*) as cnt, actor.login FROM [githubarchive:day.events_20150821]
where actor.login like 'teddy%'
group by actor.login
order by cnt desc
LIMIT 1000