ErsvanF - VIEWS - w_address_staking EVENTS - Genopets Staking
    Updated 2022-05-31
    WITH RECURSIVE w_address_staking (address,Total) AS
    (
    SELECT
    INSTRUCTION:accounts[0] AS address, COUNT(*)
    FROM
    flipside_prod_db.solana.fact_events
    WHERE
    PROGRAM_ID = 'StaKe9nb7aUjXpjpZ45o6uJBsZxj2BWCDBtjk8LCg2v'
    GROUP BY INSTRUCTION:accounts[0]
    )

    SELECT * FROM w_address_staking
    Run a query to Download Data