i_danBase DEXs: Returning Users To One Time User Percentage
    Updated 2024-09-07
    SELECT
    origin_from_address,
    CASE
    WHEN COUNT(DISTINCT tx_hash) > 1 THEN 'Returning User'
    ELSE 'One Time User'
    END AS User_Status,
    COUNT(tx_hash) AS no_of_transactions
    FROM
    base.defi.ez_dex_swaps
    GROUP BY
    1 --ORDER BY 1 DESC
    --LIMIT 100
    QueryRunArchived: QueryRun has been archived