gokcinaction
Updated 2022-09-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with transactions as (
select tx_hash as TX
from near.core.fact_transactions
where tx_receiver = 'token.sweat'
and tx_status = 'Success'
),
events as (
select ACTION_NAME as actions, TX_HASH as TX
from near.core.fact_actions_events
)
select count (DISTINCT a.TX) as transactionnuber,b.actions as actiontype
from transactions a join events b on a.TX=b.TX
group by 2
order by 1 DESC
Run a query to Download Data