WITH buyer_stats AS (

SELECT

buyer_address AS Address,

COUNT(*) AS nfts_bought,

SUM(amount) AS total_value_bought,

AVG(amount) AS average_nft_price_bought,

MIN(block_timestamp) AS first_time_bought,

MAX(block_timestamp) AS last_time_bought

FROM

sei.nft.ez_nft_sales

WHERE

project_name = 'WeBump'

GROUP BY

buyer_address

),

seller_stats AS (

SELECT

seller_address AS Address,

COUNT(*) AS nfts_sold,

SUM(amount) AS total_value_sold,

AVG(amount) AS average_nft_price_sold,

MIN(block_timestamp) AS first_time_sold,

MAX(block_timestamp) AS last_time_sold

FROM

sei.nft.ez_nft_sales

WHERE

project_name = 'WeBump'

GROUP BY

seller_address

),

combined_stats AS (

SELECT

b.Address,

b.nfts_bought,

COALESCE(s.nfts_sold, 0) AS nfts_sold,