adambalaTOP 5 seller -- number of transactions
    Updated 2022-12-09
    SELECT
    count(distinct TX_HASH ) as txs , SELLER_ADDRESS AS ADDRESS ,'SELLER for ' AS TITLE
    FROM ethereum.core.ez_nft_sales
    WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH'and NFT_ADDRESS=lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')
    group by 2,3 order by 1 desc limit 5
    Run a query to Download Data