SELECT

nft_to_address

, nft_from_address

, COUNT(tx_hash) AS amount

FROM

base.nft.ez_nft_transfers

WHERE

nft_address = lower('0x217Ec1aC929a17481446A76Ff9B95B9a64F298cF')

GROUP BY 1, 2

),

nft_transfers AS (

SELECT

nft_to_address AS address,

SUM(amount) AS amount

FROM

nft_count

GROUP BY 1

UNION ALL

SELECT

nft_from_address AS address,

SUM(- amount) AS amount

FROM

nft_count

GROUP BY 1

address

, SUM(amount) AS balance

, CASE WHEN balance >= 1 AND balance <= 5 THEN 'Novice Fella'

WHEN balance >= 6 AND balance <= 10 THEN 'Enthusiastic Fella'

WHEN balance >= 11 AND balance <= 24 THEN 'Dedicated Fella'

WHEN balance >= 25 AND balance <= 49 THEN 'Advanced Fella'