gustavopinto · September 30, 2015 20:19
diff --git a/github-popular-projects.sql b/github-popular-projects.sql
 SELECT
  a.repository_name as name,
  a.repository_owner as owner,
  a.repository_organization as organization,
  a.repository_watchers AS stars,
  a.repository_forks AS forks,
  a.repository_language as language  
 FROM (
 select *
 from [githubarchive:github.timeline] a
 where a.repository_language = "Haskell"
 ) as a
 JOIN EACH
  (
     SELECT MAX(created_at) as max_created, repository_name
     FROM [githubarchive:github.timeline]
     GROUP EACH BY repository_name
  ) as b
  ON
  b.max_created = a.created_at and
  b.repository_name = a.repository_name 
 ORDER BY stars desc
 LIMIT 10
	SELECT
	a.repository_name as name,
	a.repository_owner as owner,
	a.repository_organization as organization,
	a.repository_watchers AS stars,
	a.repository_forks AS forks,
	a.repository_language as language
	FROM (
	select *
	from [githubarchive:github.timeline] a
	where a.repository_language = "Haskell"
	) as a
	JOIN EACH
	(
	SELECT MAX(created_at) as max_created, repository_name
	FROM [githubarchive:github.timeline]
	GROUP EACH BY repository_name
	) as b
	ON
	b.max_created = a.created_at and
	b.repository_name = a.repository_name
	ORDER BY stars desc
	LIMIT 10