event_name AS event,

COUNT(DISTINCT sender) AS distinct_senders,

COUNT(DISTINCT tx_hash) AS distinct_transactions

FROM

avalanche.defi.ez_bridge_activity

WHERE

event_name IS NOT NULL

AND tx_hash IS NOT NULL

GROUP BY

event_name

ORDER BY

distinct_senders DESC, distinct_transactions DESC;