ClickHouse / ClickHouse/github-explorer

Fix for "Top commented issues for each of the top repositories"

Open
#21 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
HTML
Stars
180
Forks
19
Avg merge
3h 8m
Merged PRs (30d)
1

Description

I think `sum` is wrong here. Each row contains the total number of stars.

```patch
---
index.html | 2 +-
queries.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/index.html b/index.html
index a1b6343..03af266 100644
--- a/index.html
+++ b/index.html
@@ -3685,7 +3685,7 @@ LIMIT 50
max(comments),
argMax(authors, comments) AS authors,
argMax(number, comments) AS number,
- sum(stars) AS stars
+ any(stars) AS stars
FROM
(
SELECT *
diff --git a/queries.sql b/queries.sql
index 938e358..e7c13a6 100644
--- a/queries.sql
+++ b/queries.sql
@@ -671,7 +671,7 @@ SELECT
max(comments),
argMax(authors, comments) AS authors,
argMax(number, comments) AS number,
- sum(stars) AS stars
+ any(stars) AS stars
FROM
(
SELECT *
--
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.