[Explorer] Some problem for question 78798353-f4db-451e-888d-c33d2f485317: who contribute most to all projects written in rust?

[licq]

Hi, I have some problems with the question 78798353-f4db-451e-888d-c33d2f485317 who contribute most to all projects written in rust? (errorType = none):

Generated SQL

WITH
  cte_rust_repos AS (
    SELECT
      repo_id
    FROM
      github_repos
    WHERE
      primary_language = 'rust'
  )
SELECT
  ge.actor_login AS user_login,
  COUNT(*) AS contributions
FROM
  github_events ge
WHERE
  ge.type = 'PullRequestEvent'
  AND ge.action = 'opened'
  AND ge.repo_id IN (
    SELECT
      repo_id
    FROM
      cte_rust_repos
  )
GROUP BY
  ge.actor_login
ORDER BY
  contributions DESC
LIMIT
  20

Chart:

{
  "chartName": "BarChart",
  "title": "Contributions of users to projects written in rust",
  "x": "user_login",
  "y": "contributions"
}

Result:

// Fields
  [
  {
    "name": "user_login"
  },
  {
    "name": "contributions"
  }
]

// First result (Totally 0 rows)
  undefined

[sykp241095]

Currently the comparison is case sensitive, we will use LOWER() func in this scenario.