---CREADIT HAMED
select
text_signature,
count (DISTINCT tx_hash),
count (DISTINCT ORIGIN_FROM_ADDRESS)
from
sei.core_evm.fact_event_logs x
join ethereum.core.dim_function_signatures y on x.origin_function_signature = y.bytes_signature
GROUP BY
1
ORDER BY 2 DESC