strawbettypercentage of users that withdraw to wallets
    Updated 2022-05-02
    WITH withdraw AS(SELECT
    COUNT(DISTINCT TX_ID) AS transaction_num,
    CASE WHEN to_address_name='genesis' THEN 'wallet'
    WHEN to_address_name='sushiswap: bentoboxv1' THEN 'bento-box'
    ELSE NULL
    END AS label
    FROM ethereum.udm_events
    WHERE TX_ID = ANY(SELECT TX_ID FROM ethereum.udm_events
    WHERE TX_ID=ANY(
    SELECT TX_ID
    FROM ethereum.udm_events
    WHERE event_name='LogWithdraw'
    AND CONTRACT_ADDRESS=ANY(
    SELECT ADDRESS FROM ethereum.labels
    WHERE label='sushiswap' ))
    AND SYMBOL LIKE 'km%')
    GROUP BY 2)
    SELECT * FROM withdraw
    WHERE label IS NOT NULL;
    Run a query to Download Data