SELECT

COALESCE(seller_address, buyer_address) AS user,

COUNT(DISTINCT tx_hash) AS Sale

FROM

near.nft.ez_nft_sales

WHERE

platform_name = '{{platform_name}}'

AND block_timestamp::date BETWEEN '{{Start_Date}}' AND '{{End_Date}}'

GROUP BY user

CASE

WHEN Sale = 1 THEN '1 trade'

WHEN Sale BETWEEN 2 AND 5 THEN '2-5 trades'

WHEN Sale BETWEEN 6 AND 10 THEN '6-10 trades'

WHEN Sale BETWEEN 11 AND 20 THEN '11-20 trades'

WHEN Sale BETWEEN 21 AND 50 THEN '21-50 trades'

WHEN Sale > 50 THEN '50+ trades'

END AS trade_range,

COUNT(DISTINCT user) AS traders

FROM user_trade

WHERE Sale IS NOT NULL

GROUP BY trade_range;