c2ctrader03 - Total Number of Providinga and Removing Actions
    Updated 2022-06-11
    -- providing action (total)
    with Nprovidng as (
    select 'Providing Liquidity' "Action", count(*) "No. of Action"--, ROW_NUMBER() OVER(ORDER by count(*) ASC) Row_No
    from flipside_prod_db.ethereum_core.fact_event_logs
    where contract_name = 'NFTXStakingZap' and event_name = 'UserStaked'
    ),

    -- removing action (total)
    Nremoving as (
    select 'Removing Liquidity' "Action", count(*) "No. of Actions"--, ROW_NUMBER() OVER(ORDER by count(*) ASC) Row_No
    from flipside_prod_db.ethereum_core.fact_event_logs
    where contract_name = 'NFTXStakingZap' and event_name = 'Withdraw'
    )

    select * from Nprovidng
    union all
    select * from Nremoving



    Run a query to Download Data