SELECT

DISTINCT platform as platforms,

COUNT(DISTINCT tx_hash) AS transaction_count,

COUNT(DISTINCT sender) AS unique_sender_count,

transaction_count / unique_sender_count as Avg_tx_per_user

FROM aptos.defi.fact_bridge_activity

WHERE block_timestamp >= '2024-01-01'

GROUP BY

1

ORDER by 2 DESC