PROJECT_NAME, -- Selects the PROJECT_NAME column

AVG(TOTAL_PRICE_USD) AS AverageSalePriceUSD -- Calculates the average sale price in USD and aliases it as AverageSalePriceUSD

FROM

aptos.nft.ez_nft_sales -- Specifies the ez_nft_sales table

WHERE

PROJECT_NAME IN ( -- Filters the results to only include project names that are present in the subquery

SELECT

PROJECT_NAME -- Selects the PROJECT_NAME column in the subquery

FROM

aptos.nft.ez_nft_mints -- Specifies the ez_nft_mints table for the subquery

)

GROUP BY

PROJECT_NAME -- Groups the results by project name

LIMIT

10; -- Limits the output to the first 10 rows