mmdrezaTop unfollow
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
-- )
with 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 unfollow
--
Run a query to Download Data