kasadeghRank of user in the each host country metadata value ( Brazil, France, USA, Spain, …)
    Updated 2022-11-13

    select
    Host,
    Rank,
    NFTs_Count
    from
    (
    select address,
    Host,
    count (distinct nft_asset_id) as NFTs_Count,
    RANK() OVER (partition by Host ORDER BY NFTs_Count desc) as rank
    from algorand.core.fact_account_asset t1 join algorand.nft.ez_nft_metadata_fifa t2 on t1.asset_id = t2.nft_asset_id
    where t1.amount > 0
    group by 1,2
    )
    where address ilike '{{Wallet_Address}}'
    order by rank


    Run a query to Download Data