select tokenid,
count (distinct tx_hash) as Sales_Count,
sum (price_usd) as Total_USD_Volume
from optimism.core.ez_nft_sales
where nft_address = '0x56fe60179c13b6492c6501d36e77ccd9fb86d7c2'
and price_usd > 0
and block_timestamp::date > '2022-10-22'
group by 1 having sales_count = 1
order by 3 DESC
limit 10