SELECT
CASE
when EVENT_NAME IS NULL THEN 'TransferSentToL2'
WHEN EVENT_NAME = 'ERC20DepositInitiated' THEN 'ERC20DepositInitiated'
WHEN EVENT_NAME = 'ERC20WithdrawalFinalized' THEN 'ERC20WithdrawalFinalized'
END AS EVENT_NAME,
COUNT(CONTRACT_ADDRESS)
FROM ethereum.core.fact_event_logs
WHERE CONTRACT_ADDRESS = lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1')
-- AND EVENT_NAME = 'ERC20WithdrawalFinalized'
GROUP by 1
ORDER by 2 DESC
--LIMIT 10