FatemeTheLadySolana-open10-usdt
    Updated 2022-11-24
    with a as(
    select ADDRESS_NAME as address,
    sum(amount) as toal_amount
    from solana.core.fact_transfers t,solana.core.dim_labels l
    where t.TX_TO = l.address
    and mint= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
    group by 1
    order by 2 DESC
    limit 8
    )

    select
    date_trunc('week',BLOCK_TIMESTAMP) as date
    ,case when ADDRESS_NAME in (select address from a ) then ADDRESS_NAME else 'others' end as address
    ,sum(amount) as Amount
    from solana.core.fact_transfers t,solana.core.dim_labels l
    where t.TX_TO = l.address
    and mint= 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
    group by 1,2
    order by 1 asc
    Run a query to Download Data