WITH mwalletevent AS(

WITH METAMASKWALLETS AS(

SELECT DISTINCT ORIGIN_FROM_ADDRESS AS "Wallet Address"

FROM ethereum.core.fact_event_logs

WHERE contract_address =lower ('0x881D40237659C251811CEC9c364ef91dC08D300C')

SELECT "Wallet Address",TX_HASH,EVENT_NAME

FROM METAMASKWALLETS M

INNER JOIN

ethereum.core.fact_event_logs e ON m."Wallet Address" = e.ORIGIN_FROM_ADDRESS

)

SELECT COUNT("Wallet Address") AS "Metamask Wallets Engaging in Staking"

FROM mwalletevent me

INNER JOIN

ethereum.core.dim_dex_liquidity_pools l ON me.TX_HASH = l.CREATION_TX

),

MDW AS(

SELECT

COUNT (DISTINCT ORIGIN_FROM_ADDRESS) AS "Metamask Distinct Wallets" --count the total number of individual wallets that interact with Metamask

FROM ethereum.core.fact_event_logs E

WHERE contract_address =lower ('0x881D40237659C251811CEC9c364ef91dC08D300C')

)

SELECT "Metamask Wallets Engaging in Staking","Metamask Distinct Wallets",

("Metamask Wallets Engaging in Staking"/"Metamask Distinct Wallets")*100 AS "WALLETS STAKING ACTIVITY PERCENTAGE %"

FROM MWL,MDW