MLDZMNTop 5 most profit
    Updated 2022-06-18
    with tb1 as (select
    TOKENID,
    MINT_PRICE_USD as mint_usd
    from ethereum.core.ez_nft_mints
    where NFT_ADDRESS=lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    ),

    tb2 as (select
    TOKENID,
    sum(PRICE_USD) as sale_usd
    from ethereum.core.ez_nft_sales
    where NFT_ADDRESS=lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    group by 1)

    select
    distinct tb1.TOKENID as NFT_id,
    sale_usd-mint_usd as profit

    from tb1
    join tb2 on tb1.TOKENID=tb2.TOKENID
    group by 1,2 having profit is not null
    order by 2 desc limit 5

    Run a query to Download Data