-- forked from lil nouns day interval copy @ https://flipsidecrypto.xyz/edit/queries/3f73b2ce-9d49-402c-ae28-f10a6afb964a

-- forked from Sandesh / lil nouns day interval @ https://flipsidecrypto.xyz/Sandesh/q/EUBn6liAqO5J/lil-nouns-day-interval

with mint as

(select * from ethereum.core.ez_nft_transfers

where nft_from_address in ('0xd5f279ff9eb21c6d40c8f345a66f2751c4eea1fb','0xa6ef22a84521ddd11c1282ec8f8a9255dbac04a0')

),

transfers as (

select * from ethereum.core.ez_nft_sales

where nft_address=lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')

and nft_address not in ('0xd5f279ff9eb21c6d40c8f345a66f2751c4eea1fb','0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e')

),

sale_interval as (

select t.tx_hash,t.block_timestamp as transfer_date, m.block_timestamp as mint_date,m.tokenid, t.SELLER_ADDRESS,t.BUYER_ADDRESS ,t.PRICE_USD,

datediff('day',mint_date,transfer_date) as long_column_name_to_demo_this

from transfers t left join mint m

on t.tokenid=m.tokenid

where m.tokenid is not null

)

select long_column_name_to_demo_this, count(tokenid) as numer_of_NFT_sold,sum(PRICE_USD) as total_amount,avg(PRICE_USD) as average_amount from sale_interval

group by 1