SELECT tx_hash, buyer_address, project_name, total_price, total_price_usd, seller_address, creator_fee_usd

FROM aptos.nft.ez_nft_sales

WHERE project_name ilike '%Aptomingos%'

select count (DISTINCT tx_hash) as total_sales,

count (DISTINCT buyer_address) as buyers,

count (DISTINCT seller_address) as sellers,

sum (total_price) as apt_sales_volume,

sum (total_price_usd) as usd_sales_volume,

sum (creator_fee_usd) as creator_fee

from main