KaskoazulFF holders
    Updated 2022-03-27
    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