Sign in
apache
/
doris
/
refs/heads/variant-sparse-merge
/
.
/
regression-test
/
suites
/
variant_p2
/
sql
/
authorsWithTheMostPushes.sql
blob: c4e6e645d8bf46daa830eb5a9f10595c293751d6 [
file
] [
log
] [
blame
]
SELECT
cast
(
actor
[
'login'
]
as
string
),
count
()
AS
c
,
count
(
distinct
cast
(
repo
[
'name'
]
as
string
))
AS
repos
FROM
github_events
WHERE
type
=
'PushEvent'
GROUP
BY
cast
(
actor
[
'login'
]
as
string
)
ORDER
BY
c
DESC
,
1
,
3
LIMIT
50