flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Top 10 Stats
rajs
Top 10 Stats
Updated 2023-01-25
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
author
,
org
,
repo
,
count
(
*
)
as
no_of_actions
,
count
(
distinct
date_trunc
(
'day'
,
updatedat
)
)
as
no_of_days_active
from
near
.
beta
.
github_activity
group
by
1
,
2
,
3
order
by
4
desc
Results
Run a query to Download Data