mmdrezaFollow adn 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
›
⌄
with follow as (
select
'follow' as type,
count(distinct tx_hash) as follow
from near.social.fact_decoded_actions
where node_data:graph ilike '%follow%'
group by 1
),
unfollow as (
select
'unfollow' as type,
count(distinct tx_hash) as Unfollow
from near.social.fact_decoded_actions
where node_data:graph ilike '%unfollow%'
group by 1
)
select * from follow
union all
select * from unfollow
Run a query to Download Data