ethereum.core.dim_nft_metadata.TOKEN_METADATA:Background,

SUM(PRICE_USD) as Volume_Sold,

avg(price_usd) as Average_Price,

((count(distinct ethereum.core.dim_nft_metadata.TOKEN_id))*.01) as Rarity --since you multiple by 100 and divide by 10,000 same as just multiplying by .01.

from ethereum.core.ez_nft_sales left outer join ethereum.core.dim_nft_metadata

on ethereum.core.ez_nft_sales.TOKENID = ethereum.core.dim_nft_metadata.TOKEN_id

where ethereum.core.dim_nft_metadata.project_name like 'bored_ape_yacht_club'

group by 1

order by 2 DESC

limit 25