Zanyar_98Top 3 Auction in terms of the highest number of participants - Arbitrum
    Updated 2022-09-19
    WITH Project_On_Arbitrum AS (
    SELECT Contract_Address
    FROM Arbitrum.core.fact_event_logs
    WHERE ORIGIN_TO_ADDRESS='0x3db923fbab372ab8c796fef9bb8341cdb37cb9ec' AND
    ORIGIN_FUNCTION_SIGNATURE = '0xfa18022c' AND EVENT_NAME='AuctionTimeUpdated')

    SELECT COUNT(DISTINCT(FROM_ADDRESS)) AS "Number of participants", To_ADDRESS AS "Auction"
    FROM Arbitrum.core.fact_transactions
    WHERE To_ADDRESS IN (SELECT Contract_Address FROM Project_On_Arbitrum)
    GROUP BY "Auction"
    ORDER BY "Number of participants" DESC
    LIMIT 3
    Run a query to Download Data