count(distinct (tx_hash)) as tx,

case

when tx_receiver = 'token.sweat' then 'token.sweat'

when tx_receiver = 'app.nearcrowd.near' then 'app.nearcrowd.near'

else 'other'

end as tokem_type

near.core.fact_transactions

tx_status = 'Success'

group by

tokem_type