Query editor
-- Query 2: Top 250 depositors by total amount depositedWITH user_deposits AS (SELECTtoAddress AS Wallet,SUM(amount) / 1e6 AS Total_Deposit_Amount, -- Assuming 6 decimals for USDCCOUNT(*) AS Total_Deposit_CountFROM lighter_v2_ethereum.zklighter_evt_depositGROUP BY toAddress)SELECTROW_NUMBER() OVER (ORDER BY Total_Deposit_Amount DESC) AS Rank,Wallet,ROUND(Total_Deposit_Amount, 2) AS Total_USDC_Deposited,Total_Deposit_Count AS Number_of_Deposits,ROUND(Total_Deposit_Amount / Total_Deposit_Count, 2) AS Avg_Deposit_Size,CASEWHEN Total_Deposit_Count = 1 THEN '1 deposit only'WHEN Total_Deposit_Count BETWEEN 2 AND 5 THEN '2–5 deposits'WHEN Total_Deposit_Count BETWEEN 6 AND 15 THEN '6–15 deposits'WHEN Total_Deposit_Count BETWEEN 16 AND 50 THEN '16–50 deposits'ELSE '51+ deposits'END AS Deposit_TierFROM user_depositsORDER BY Total_Deposit_Amount DESCLIMIT 250;