from ethereum.core.fact_event_logs WHERE origin_to_address = '0xa0c68c638235ee32657e8f720a23cec1bfc77c77'),---i us general adress contract

first_tx as (SELECT origin_from_address,origin_to_address,tx_hash,block_timestamp,event_name,contract_name

FROM polygon.core.fact_event_logs),----i us data in tabal

sinas as (SELECT w.origin_from_address,k.tx_hash,k.event_name,k.contract_name,k.origin_to_address,

min(k.block_timestamp) as first_dis FROM min2 w INNER JOIN first_tx k ON w.origin_from_address = k.origin_from_address

WHERE k.block_timestamp > w.block_timestamp

GROUP BY 1,2,3,4,5)

SELECT COUNT(tx_hash) as txn,event_name FROM sinas

WHERE event_name is not NULL GROUP BY 2 ORDER BY txn DESC LIMIT 10----This code is for getting the top ten activities after transferring assets