Eman-RazDistribution of token creators based on Number of Chains for Deployment
    Updated 2024-02-08
    `` .with final_tab2 as (with final_tab as (with polygon as (Select decoded_log:refundAddress as creator_address, 'Polygon' as "Deployed Chain", decoded_log:destinationChain as "Registered Chain"
    From polygon.core.fact_decoded_event_logs
    Where decoded_log:destinationAddress='0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
    and event_name='NativeGasPaidForContractCall' and
    Decoded_log:sourceAddress='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c'),


    arbitrum as (Select decoded_log:refundAddress as creator_address, 'Arbitrum' as "Deployed Chain", decoded_log:destinationChain as "Registered Chain"
    From arbitrum.core.fact_decoded_event_logs
    Where decoded_log: destinationAddress='0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
    and event_name='NativeGasPaidForContractCall' and
    Decoded_log:sourceAddress='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c'),


    avalanche as (Select decoded_log:refundAddress as creator_address, 'Avalanche' as "Deployed Chain", decoded_log:destinationChain as "Registered Chain"
    From avalanche.core.fact_decoded_event_logs
    Where decoded_log: destinationAddress='0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
    and event_name='NativeGasPaidForContractCall' and
    Decoded_log:sourceAddress='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c'),


    bsc as (Select decoded_log:refundAddress as creator_address, 'BSC' as "Deployed Chain", decoded_log:destinationChain as "Registered Chain"
    From bsc.core.fact_decoded_event_logs
    Where decoded_log: destinationAddress='0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
    and event_name='NativeGasPaidForContractCall' and
    Decoded_log:sourceAddress='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c'),


    base as (Select decoded_log:refundAddress as creator_address, 'Base' as "Deployed Chain", decoded_log:destinationChain as "Registered Chain"
    From base.core.fact_decoded_event_logs
    Where decoded_log: destinationAddress='0xB5FB4BE02232B1bBA4dC8f81dc24C26980dE9e3C'
    and event_name='NativeGasPaidForContractCall' and
    Decoded_log:sourceAddress='0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c'),


    ethereum as (Select decoded_log:refundAddress as creator_address, 'Ethereum' as "Deployed Chain", decoded_log:destinationChain as "Registered Chain"
    Last run: about 1 year agoAuto-refreshes every 12 hours
    Number of Chains for Deployment
    Token Creator Count
    1
    1223
    2
    284
    3
    322
    4
    418
    5
    513
    6
    711
    7
    65
    7
    50B
    248s