sum(sales_amount) as Sol_volume,

avg(sales_amount) as Avg_price,

count(distinct tx_id) as Sales_count,

count(distinct purchaser) as Buyer_count

from solana.core.fact_nft_sales S

join solana.core.dim_labels l on S.mint = l.address

where (address_name ilike 'The Suites'

or address_name ilike 'Collectorz Club: The Collectorz'

or address_name ilike 'Laidback Lions'

or address_name ilike 'Hockey Heroes'

or address_name ilike 'Sports Rewind'

)

and block_timestamp >= '2022-02-01