mmdrezatop 10 following
Updated 2023-06-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with follow as (
select
distinct signer_id as users,
count(distinct tx_hash) as follow
from near.social.fact_decoded_actions
where node_data:graph ilike '%follow%'
group by 1
order by 2 desc
limit 10
)
-- unfollow as (
-- select
-- distinct signer_id as users,
-- count(distinct tx_hash) as Unfollow
-- from near.social.fact_decoded_actions
-- where node_data:graph ilike '%unfollow%'
-- group by 1
-- order by 2 desc
-- limit 10
-- )
select * from follow
Run a query to Download Data