PierandreaUntitled Query
    Updated 2022-12-09
    with sales as (SELECT
    NFT_ASSET_ID as x,
    BLOCK_TIMESTAMP::date as Date,
    TOTAL_SALES_AMOUNT_USD
    from algorand.nft.ez_nft_sales_fifa
    WHERE SALE_TYPE = 'secondary'
    AND TOTAL_SALES_AMOUNT_USD != '0'
    order by 3 DESC
    LIMIT 1 ),

    rarity as (SELECT
    NFT_ASSET_ID as y,
    NFT_ASSET_NAME,
    DROP_NAME,
    ITEM_NO,
    RARITY,
    WORLD_CUP_TYPE,
    COUNTRY_1_SCORE || '-' || COUNTRY_2_SCORE as Score,
    EVENT_TYPE,
    PLAYER,
    MINUTE
    --CONCAT('https://collect.fifa.com/marketplace/', LEFT(FullN,6)) as Website
    from algorand.nft.ez_nft_metadata_fifa ),
    merge as (select *
    from sales
    inner join rarity on sales.x = rarity.y)

    select *
    from merge


    Run a query to Download Data