select 'Optimism' as category,
count (distinct tx_hash) as no_of_transactions,
count (distinct buyer_address) as no_of_buyers,
count (distinct seller_address) as no_of_sellers,
sum (price_usd) as usd_amount_total,
max (price_usd) as usd_amount_maximum
from optimism.core.ez_nft_sales
union all
select 'Ethereum' as category,
count (distinct tx_hash) as no_of_transactions,
count (distinct buyer_address) as no_of_buyers,
count (distinct seller_address) as no_of_sellers,
sum (price_usd) as usd_amount_total,
max (price_usd) as usd_amount_maximum
from ethereum.core.ez_nft_sales