price_usd, token_id, tx_id

from ethereum.nft_events

where contract_address in ('0x059edd72cd353df5106d2b9cc5ab83a52287ac3a', '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270')

and event_type = 'sale'),

artists as (select token_metadata:artist::string as Artist,

token_metadata:curation_status::string as Curation,

token_metadata:collection_name::string as Collection,

token_id

from ethereum.nft_metadata

where contract_address in ('0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270', '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a') and token_metadata:curation_status::string in ('playground','curated')

)

select b.artist, b.collection, b.curation, sum(a.price_usd) as volume, avg(a.price_usd) as Average_sales_price, count(b.token_id) as Total_Token

from vol a

join artists b on a.token_id = b.token_id

where artist in (select token_metadata:artist::string as Artist

from ethereum.nft_metadata

where contract_address in ('0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270', '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a') and token_metadata:curation_status::string = 'playground'

group by 1)

group by 1,2,3