[Explorer] Some problem for question 0f531d2f-89f6-405c-ae4d-624ff49b2d0a: how many contributors are there to trino compared to starrocks

[alberttwong]

Hi, I have some problems with the question 0f531d2f-89f6-405c-ae4d-624ff49b2d0a how many contributors are there to trino compared to starrocks (errorType = none):

Generated SQL

WITH
  trino_contributors AS (
    SELECT
      COUNT(DISTINCT creator_user_login) AS trino_contributors
    FROM
      github_events
    WHERE
      type = 'PullRequestEvent'
      AND action = 'opened'
      AND repo_name = 'trinodb/trino'
  ),
  starrocks_contributors AS (
    SELECT
      COUNT(DISTINCT creator_user_login) AS starrocks_contributors
    FROM
      github_events
    WHERE
      type = 'PullRequestEvent'
      AND action = 'opened'
      AND repo_name = 'starrocks/starrocks'
  )
SELECT
  trino_contributors,
  starrocks_contributors
FROM
  trino_contributors,
  starrocks_contributors

Chart:

{
  "chartName": "BarChart",
  "title": "Contributors to Trino vs Starrocks",
  "x": "Repository",
  "y": [
    "Trino Contributors",
    "Starrocks Contributors"
  ]
}

Result:

// Fields
  [
  {
    "columnType": 8,
    "name": "trino_contributors"
  },
  {
    "columnType": 8,
    "name": "starrocks_contributors"
  }
]

// First result (Totally 1 rows)
  {
  "starrocks_contributors": 0,
  "trino_contributors": 556
}