with mint as(
select tokenid as id, min(block_timestamp::date) as mint_time
from ethereum.core.ez_nft_mints
where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b'
group by 1
)
select tokenid, case
when block_timestamp::date between mint_time and mint_time + 1 then 'sold within 24 hours'
else 'dont sold within 24 hours' end as type
from ethereum.core.ez_nft_sales, mint
where nft_address = '0x4b10701bfd7bfedc47d50562b76b436fbb5bdb3b' and tokenid = id
order by tokenid asc