gokcinaction
    Updated 2022-09-23
    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