select tx_hash as TX

from near.core.fact_transactions

where tx_status = 'Success' AND BLOCK_TIMESTAMP>= CURRENT_DATE-14

),

events as (

select ACTION_NAME as actions, TX_HASH as TX

from near.core.fact_actions_events

WHERE BLOCK_TIMESTAMP>= CURRENT_DATE-14

)

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