[Explorer] Some problem for question f61f92c7-1b82-42c3-9914-7dc3ec2a4d3c: Trends in embedded software development

[harwHarw03]

Hi, I have some problems with the question f61f92c7-1b82-42c3-9914-7dc3ec2a4d3c Trends in embedded software development (errorType = none):

The repository's stars shown by the response doesn't match with the real stars on the repository.

Generated SQL

SELECT
  gr.repo_name,
  COUNT(*) AS stars
FROM
  github_events ge
  JOIN github_repos gr ON ge.repo_id = gr.repo_id
WHERE
  LOWER(gr.description) LIKE LOWER('%embedded software%')
  AND ge.created_at > DATE_SUB(NOW(), INTERVAL 1 YEAR)
GROUP BY
  gr.repo_name
ORDER BY
  stars DESC
LIMIT
  20

Chart:

{
  "chartName": "Table",
  "columns": [
    "repo_name",
    "stars",
    "primary_language",
    "repos_count"
  ],
  "title": "Trends in Embedded Software Development"
}

Result:

// Fields
  [
  {
    "columnType": 253,
    "name": "repo_name"
  },
  {
    "columnType": 8,
    "name": "stars"
  }
]

// First result (Totally 20 rows)
  {
  "repo_name": "MikroElektronika/mikrosdk_v2",
  "stars": 5025
}