hyoeisemanCopy of G9
    Updated 2022-11-05
    with tab1 as (select
    count (distinct origin_from_address) as count_users_GNS,
    count (distinct tx_hash) as count_transactions_GNS,
    'GNS' as type
    from polygon.core.fact_event_logs
    where contract_address = '0xe5417af564e4bfda1c483642db72007871397896'
    and event_name ilike 'transfer'
    and tx_status ilike 'SUCCESS'
    ),
    tab2 as (select
    count (distinct from_address) as count_users_POLYGON,
    count (distinct tx_hash) as count_transactions_POLYGON, 'Polygon' as type
    from polygon.core.fact_transactions
    where status ilike 'SUCCESS'
    )
    SELECT count_users_GNS*100/count_users_POLYGON AS USER_PERCENTAGE,
    count_transactions_GNS*100/count_transactions_POLYGON AS TRANSACTION_PERCENTAGE from tab1, tab2

    Run a query to Download Data