Afonso_Diaz2024-06-09 11:53 PM
Updated 2024-06-09
9
1
2
3
4
5
6
7
8
›
⌄
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