github2.sql

SELECT repository_url, repository_language
    FROM [publicdata:samples.github_timeline] AS t1
    WHERE repository_language IN
      (SELECT repository_language FROM
      (SELECT repository_language, COUNT(repository_url) AS count
        FROM [publicdata:samples.github_timeline] AS t2
        WHERE t2.repository_url = t1.repository_url AND t2.repository_url IS NOT NULL AND repository_language IS NOT NULL
        GROUP EACH BY repository_language
        ORDER BY count DESC)
      LIMIT 1)
    GROUP EACH BY repository_url, repository_language
  -- Error: Failed to find field t1.repository_url in schema message
  -- Msg_0_CLOUD_QUERY_TABLE { optional string repository_url = 1; optional
  -- string repository_language = 17; } Field repository_language preserves
  -- nulls Field repository_url preserves nulls