Eman-RazDistribution of Buyers Based on the Number of Tickets Purchased
    Updated 2024-01-15
    with tab1 as
    (select origin_from_address as "Buyer", round(sum(amount)/0.05) as "Ticket Count"
    from ethereum.core.ez_native_transfers
    where origin_to_address='0xee72f1035c706478f84ab9480e45b427aa6b6682' and
    identifier='CALL_ORIGIN' and origin_function_signature='0x2f366637'
    group by 1)

    select "Ticket Count", count(distinct "Buyer") as "Buyer Count"
    from tab1
    group by 1
    order by 1
    QueryRunArchived: QueryRun has been archived