token_metadata:artist::string as Artist,

count (distinct token_metadata:collection_name::string) as Playground

from ethereum.nft_metadata

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

group by 1),

playground as (select

token_metadata:artist::string as Artist,

count (distinct token_metadata:collection_name::string) as curated

from ethereum.nft_metadata

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

group by 1)

select a.artist, a.playground as playground_projects,

case when b.curated is null then '1' else b.curated

end as curated_projects

from artists a

left join playground b on a.artist = b.artist

order by 2 desc