shahdadi-9ptm8YUntitled Query
Updated 2022-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with c as (select distinct BUYER_ADDRESS a,max(block_timestamp) date
from flipside_prod_db.ethereum_core.ez_nft_sales
where nft_address = lower('0x23581767a106ae21c074b2276D25e5C3e136a68b')
group by a
),d as (
select distinct BUYER_ADDRESS b
from flipside_prod_db.ethereum_core.ez_nft_sales
where nft_address = lower ('0x64b6b4142d4D78E49D53430C1d3939F2317f9085')
)
select b
from c join d on c.a=d.b
Run a query to Download Data