with tab1 as (

select BUYER_ADDRESS

,sum(PRICE) as volume

,avg(PRICE) as avg_volume

,count(distinct TOKENID) as nft_sold

,count(distinct TX_HASH) as sale_count

from base.nft.ez_nft_sales

group by 1)

select 'BUYER' as user

,avg(nft_sold) as avg_nft_bought

,avg(sale_count) as avg_buy_count

from tab1

group by 1