-- 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