Afonso_Diaz2024-06-09 11:53 PM
    Updated 2024-06-09
    lifiselect event_name, tx_hash from ethereum.core.ez_decoded_event_logs
    where origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    qualify row_number() over (partition by event_name order by tx_hash) = 1

    select event_name, count(distinct tx_hash) from ethereum.core.ez_decoded_event_logs
    where origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
    group by 1
    order by 2 desc
    QueryRunArchived: QueryRun has been archived