((SELECT address,label from solana.labels

where

label = 'boryoku dragonz' or label = 'solsteads surreal estate' or label = 'mindfolk' or label = 'galactic geckos' or label = 'portals' or label = 'shadowy super coder dao'

or label = 'famous fox federation')),

a_l as

(SELECT mint as address,contract_name as label

from solana.dim_nft_metadata

-- where project_name ilike '%Degen Ape %'

where contract_name = 'Solana Monkey Business' or contract_name = 'DeGods' or contract_name = 'SOLGods'

or contract_name = 'Cets On Creck' or contract_name = 'Pesky Penguins'

or contract_name = 'Meerkat Millionaires' or contract_name = 'Astrals'

or contract_name = 'Taiyo Robotics' or contract_name = 'Catalina Whale Mixer'

or contract_name = 'Aurory' or contract_name = 'Stoned Ape Crew'

or contract_name = 'Thugbirdz' or contract_name = 'Degen Apes'),

both_ as

(SELECT * from addr_label

UNION ALL

SELECT * FROM a_l)

SELECT date(block_timestamp) as day, label, sum(sales_amount) as total_vol, count(DISTINCT purchaser) as purchasers

from

(SELECT * from solana.fact_nft_sales

inner join both_

on mint = address)

where succeeded = 'TRUE'

GROUP by 1 , 2