KaskoazulFF holders
Updated 2022-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with FF_HOLDERS as (
select distinct user_address,
address_name,
balance as FF_balance,
symbol
from ethereum.erc20_balances
where contract_address = lower('0x7E9D8f07A64e363e97A648904a89fb4cd5fB94CD')
and balance_date = '2022-03-23'
and balance > 0
order by 3 desc
)
select case
when FF_balance >= 0 and FF_balance < 1 then 'No Tier'
when FF_balance >= 1 and FF_balance < 10 then '1 $FF Tier'
when FF_balance >= 10 and FF_balance < 100 then '10 $FF Tier'
when FF_balance >= 100 and FF_balance < 200 then '100 $FF Tier'
when FF_balance >= 200 and FF_balance < 300 then '200 $FF Tier'
when FF_balance >= 300 and FF_balance < 500 then '300 $FF Tier'
when FF_balance >= 500 and FF_balance < 1000 then '500 $FF Tier'
when FF_balance >= 1000 and FF_balance < 2000 then '1000 $FF Tier'
when FF_balance >= 2000 and FF_balance < 5000 then '2000 $FF Tier'
when FF_balance >= 5000 and FF_balance < 10000 then '5000 $FF Tier'
when FF_balance >= 10000 then '10000 $FF Tier'
else NULL
end as tier,
case
when FF_balance >= 0 and FF_balance < 1 then 1
when FF_balance >= 1 and FF_balance < 10 then 2
when FF_balance >= 10 and FF_balance < 100 then 3
when FF_balance >= 100 and FF_balance < 200 then 4
when FF_balance >= 200 and FF_balance < 300 then 5
when FF_balance >= 300 and FF_balance < 500 then 6
when FF_balance >= 500 and FF_balance < 1000 then 7
when FF_balance >= 1000 and FF_balance < 2000 then 8
when FF_balance >= 2000 and FF_balance < 5000 then 9
Run a query to Download Data