SajjadiiiSei \\ Pallet Market - Top Sallers Sales Count ( 1 Visualization With Time Parameter)
    Updated 2024-04-16
    SELECT Seller_address AS "Seller"
    ,count(DISTINCT tx_id) AS "Sales Count"
    ,round(sum(amount) , 2)AS "Sales $SEI"
    FROM sei.nft.ez_nft_sales
    WHERE block_timestamp::date >= current_date - interval '{{num_of_period}} {{period}}'
    AND platform_name = 'pallet'
    GROUP BY Seller_address
    ORDER BY 2 DESC
    LIMIT 5