-- forked from AVG DAYS OF HOLDING @ https://flipsidecrypto.xyz/edit/queries/6bfee81d-6c11-40f5-9d91-0ba7c0e71d66
select
avg(datediff('day', a.block_timestamp, b.block_timestamp)) as avg_days_of_holding
from
flow.nft.ez_nft_sales a
join flow.nft.ez_nft_sales b on a.buyer = b.seller
and a.nft_id = b.nft_id
where
a.NFT_COLLECTION LIKE '%GarageCard%'
and datediff('day', a.block_timestamp, b.block_timestamp) > 0