when nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'supporter'

when nft_address = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' then 'lawyer'

when nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'judge'

end as pooly

from ethereum.core.ez_nft_transfers

where nft_address in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed', '0x3545192b340f50d77403dc0a64cf2b32f03d00a9', '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')),

lasts as (select nft_to_address, count(distinct tokenid) as nfts_owned

from raw

group by 1)

select nfts_owned, count (distinct nft_to_address) as cntt

from lasts

group by 1