3 ms·
Running the BigQuery myself: SELECT repository_language, SUM(IF(PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2014-01-01 00:00:00') AND PARSE_UT
by minimaxir 12y ago
Running the BigQuery myself:
SELECT repository_language,
SUM(IF(PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2014-01-01 00:00:00') AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC('2014-08-30 00:00:00'), 1, 0)) / SUM(IF(PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2013-01-01 00:00:00') AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC('2013-08-30 00:00:00'), 1, 0)) * 100 as perc_increase
FROM [githubarchive:github.timeline]
WHERE repository_fork == "false"
AND type == "CreateEvent"
GROUP BY repository_language
HAVING SUM(IF(PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2014-01-01 00:00:00') AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC('2014-08-30 00:00:00'), 1, 0)) > 1000
ORDER BY perc_increase DESC'
Gives me similar results to the OP.