MLDZMNTop 5 most profit
Updated 2022-06-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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