Query editor
WITH arbitrum_tx_count AS (SELECT`from` AS address,count(hash) AS tx_countFROMarbitrum.transactionsWHEREsuccess = trueAND !(`to` = '0x000000000000000000000000000000000000006e' AND substring(`data`, 1, 10) = '0x679b6ded') -- ArbRetryableTxAND block_time > '2021-05-29' -- frst day-- AND block_time < date_trunc('DAY', current_timestamp()) -- Exclude TodayGROUP BY`from`)SELECTCASEWHEN tx_count >= 101 THEN '>= 101 Tx'WHEN tx_count >= 51 THEN '51 ~ 100 Tx'WHEN tx_count >= 21 THEN '21 ~ 50 Tx'WHEN tx_count >= 11 THEN '11 ~ 20 Tx'WHEN tx_count >= 6 THEN '6 ~ 10 Tx'ELSE '1 ~ 5 Tx'END AS tx_count_range,count(address) AS user_countFROMarbitrum_tx_countGROUP BYtx_count_rangeORDER BYuser_count DESC-- SELECT-- CASE-- WHEN active_week_count >= 10 THEN '>= 10 Weeks'-- WHEN active_week_count >= 8 THEN '8 ~ 9 Weeks'-- WHEN active_week_count >= 6 THEN '6 ~ 7 Weeks'-- WHEN active_week_count >= 4 THEN '4 ~ 5 Weeks'-- WHEN active_week_count >= 2 THEN '2 ~ 3 Weeks'-- ELSE '1 Weeks'-- END AS active_week_range,-- count(address) AS user_count-- FROM-- user_tx_overview-- GROUP BY-- active_week_range-- ORDER BY-- user_count DESC