[Explorer] no result for question bba7e18c-b0df-448a-9aa8-dcc1fc04e87c: please tell me , the top commiter per month at kubernetes repo, since 2018.

[samzong]

Hi, I have some problems with the question bba7e18c-b0df-448a-9aa8-dcc1fc04e87c please tell me , the top commiter per month at kubernetes repo, since 2018. (errorType = none):

Generated SQL

SELECT
  DATE_FORMAT(ge.created_at, '%Y-%m') AS t_month,
  gu.login AS top_committer,
  COUNT(*) AS commit_count
FROM
  github_events ge
  INNER JOIN github_users gu ON ge.actor_id = gu.id
WHERE
  ge.repo_name = 'kubernetes/kubernetes'
  AND ge.type = 'PushEvent'
  AND ge.created_at >= '2018-01-01'
GROUP BY
  t_month,
  top_committer
ORDER BY
  t_month,
  commit_count DESC

Chart:

{
  "chartName": "Table",
  "columns": [
    "Month",
    "Top Committer",
    "Commit Count"
  ],
  "title": "Top Committer per Month at Kubernetes Repo since 2018"
}

Result:

// Fields
  [
  {
    "columnType": 253,
    "name": "t_month"
  },
  {
    "columnType": 253,
    "name": "top_committer"
  },
  {
    "columnType": 8,
    "name": "commit_count"
  }
]

// First result (Totally 188 rows)
  {
  "commit_count": 640,
  "t_month": "2018-01",
  "top_committer": "k8s-github-robot"
}