ValiMohammadicomparison between ETHEREUM and OPTIMISM Nft sales
    Updated 2022-10-19
    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
    Run a query to Download Data