with tab1 as (

select SELLER_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 'SELLER' as user

,avg(nft_sold) as avg_nft_sold

,avg(sale_count) as avg_sale_count

from tab1

group by 1