with alldata AS

with database as

select BLOCK_TIMESTAMP,TX_HASH,MEMO,LOG_EVENT_INDEX,OWNER_ID,SYMBOL,OLD_OWNER_ID,NEW_OWNER_ID,TOKEN_AMOUNT_ADJ,AMOUNT_USD

from $query('6539c74d-1822-495e-b77a-d376b9271099')

where MEMO in ('deposit')

SELECT

owner_id as "Address",

count (DISTINCT tx_hash) as "Total Deposits",

sum (amount_usd) as "Total deposit volume (USD)"

from database

group by 1

order by 2 desc

SELECT CASE

WHEN "Total Deposits" >= 10 THEN 'Tier1: more than 10 Deposits'

WHEN "Total Deposits" >= 5

and "Total Deposits" < 10 THEN 'Tier2: 5-10 Deposits'

WHEN "Total Deposits" >= 2

and "Total Deposits" < 5 THEN 'Tier3: 2-5 Deposits'

WHEN "Total Deposits" =1 THEN 'Tier4: only 1 Deposit'

END AS "Tier"

, COUNT(1) AS "Total Addresses"

, SUM("Total Deposits") AS "Tier Total Deposits"

FROM alldata

GROUP BY 1