marketplace,

count(distinct TX_ID) as total_number_of_sales,

sum(SALES_AMOUNT) as total_sales_price

from

solana.core.fact_nft_sales a join solana.core.dim_labels b on a.MINT=b.ADDRESS

where

SUCCEEDED and

address_name in ('Hockey Heroes','Collectorz Club: The Collectorz','collectorz club gen1','The Suites','Laidback Lions','Sports Rewind')

group by

1

order by

1