boomer77Untitled Query
Updated 2021-09-08
9
1
2
3
4
5
6
7
›
⌄
select
token_metadata:artist::string as Artist,
count (distinct token_metadata:collection_name::string) as Playground,
case when Playground is not null then '0' else Playground end as Counts
from ethereum.nft_metadata
where contract_address in ('0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270', '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a') and token_metadata:curation_status::string = 'playground'
group by 1
Run a query to Download Data