Sign in
apache
/
doris
/
refs/heads/fix-null-offset-array
/
.
/
regression-test
/
suites
/
github_events_p2
/
sql
/
issuesWithTheMostComments5.sql
blob: fff6d9c36912bcfd6fd1ac0d2b793ced49d32ac0 [
file
]
SELECT
repo_name
,
number
,
count
()
AS
comments
FROM
github_events
WHERE
event_type
=
'IssueCommentEvent'
AND
(
action
=
'created'
)
AND
(
number
>
10
)
GROUP
BY
repo_name
,
number
ORDER
BY
comments
DESC
,
repo_name
,
number
LIMIT
50