[Explorer] Visualization failed for question e5afe21b-bc00-49d7-8453-f838175fe1cc: In GitHub, what are the top 10 Chinese enterprises that own the most popular projects?

[KateElizabethWang]

Hi, Visualization failed for question e5afe21b-bc00-49d7-8453-f838175fe1cc In GitHub, what are the top 10 Chinese enterprises that own the most popular projects? (errorType = none):

Generated SQL

SELECT
  gu.organization AS enterprise,
  SUM(gr.stars) AS total_stars
FROM
  github_repos gr
  JOIN github_users gu ON gr.owner_id = gu.id
WHERE
  gu.type = 'ORG'
  AND gu.country_code = 'CN'
GROUP BY
  enterprise
ORDER BY
  total_stars DESC
LIMIT
  10

Chart:

{
  "chartName": "BarChart",
  "title": "Top 10 Chinese Enterprises with the Most Popular Projects in GitHub",
  "x": "enterprise",
  "y": "total_stars"
}

Result:

// Fields
  [
  {
    "name": "enterprise"
  },
  {
    "name": "total_stars"
  }
]

// First result (Totally 1 rows)
  {
  "enterprise": null,
  "total_stars": 6241467
}