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;