Updated 2025-03-16
    SELECT
    a.TO_ADDRESS,
    COUNT(*) AS call_count
    FROM bsc.core.fact_traces as a, bsc.core.dim_contracts as b
    WHERE

    a.to_address = b.address
    and SUBSTRING(a.input, 3, 8) = '1626ba7e'
    GROUP BY a.TO_ADDRESS, a.input
    HAVING COUNT(*) > 1;