(SELECT case when background is NULL then 'NULL' else background end as background_type, count(*) as total_backgrounds from

(SELECT *, token_metadata:background as background

from ethereum.nft_metadata

where contract_address ilike '0x23581767a106ae21c074b2276D25e5C3e136a68b')

GROUP by background,1),

eyes as

(SELECT case when eye is NULL then 'NULL' else eye end as eye_type, count(*) as total_eyes from

(SELECT *, token_metadata:eyes as eye

from ethereum.nft_metadata

where contract_address ilike '0x23581767a106ae21c074b2276D25e5C3e136a68b')

GROUP by eye,1)

, token_data as

(SELECT token_name,

case when background is NULL then 'NULL' else background end as background_type_ ,

case when beak is NULL then 'NULL' else beak end as beak_type_ ,

case when body is NULL then 'NULL' else body end as body_type_ ,

case when feathers is NULL then 'NULL' else feathers end as feather_type_ ,

case when headwear is NULL then 'NULL' else headwear end as headwear_type_,

case when eyes is NULL then 'NULL' else eyes end as eyes_type_

from

(SELECT *, token_metadata:background as background

, token_metadata:beak as beak

, token_metadata:body as body

, token_metadata:feathers as feathers

, token_metadata:headwear as headwear

, token_metadata:eyes as eyes

from ethereum.nft_metadata

where contract_address ilike '0x23581767a106ae21c074b2276D25e5C3e136a68b') ),

bodies as

(SELECT case when body is NULL then 'NULL' else body end as body_type, count(*) as total_bodies from

(SELECT *, token_metadata:body as body

from ethereum.nft_metadata

where contract_address ilike '0x23581767a106ae21c074b2276D25e5C3e136a68b')

GROUP by body,1),