0-MIDstake share
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with act1 as (
with tab1 as (
SELECT TX_HASH
from near.core.ez_token_transfers
where CONTRACT_ADDRESS='linear-protocol.near'
and MEMO='stake'
)
select FROM_ADDRESS
,count(distinct TX_HASH) as stakes
from near.core.ez_token_transfers
where TX_HASH in (select TX_HASH from tab1)
and TO_ADDRESS='linear-protocol.near'
group by 1
)
select case
when stakes=1 then 'One Stake' else 'More Than One Stake' end as s_dis
,count(distinct FROM_ADDRESS) as stakers
from act1
group by 1
order by 1
QueryRunArchived: QueryRun has been archived