EVENT_TYPE AS "_SALES",

SUM(Ethereum_Sales) AS "Ethereum_Sales",

SUM(Optimism_Sales) AS "Optimism_Sales",

SUM(Polygon_Sales) AS "Polygon_Sales",

SUM(Ethereum_Fees_USD) AS "Ethereum_Fees_USD",

SUM(Optimism_Fees_USD) AS "Optimism_Fees_USD",

SUM(Polygon_Fees_USD) AS "Polygon_Fees_USD"

(SELECT

EVENT_TYPE,

COUNT(EVENT_TYPE) AS Ethereum_Sales,

SUM(total_fees_usd) AS Ethereum_Fees_USD,

0 AS Optimism_Sales,

0 AS Optimism_Fees_USD,

0 AS Polygon_Sales,

0 AS Polygon_Fees_USD

FROM

ethereum.core.ez_nft_sales

WHERE

EVENT_TYPE = 'sale'

AND block_timestamp >= CURRENT_DATE - interval '7 day'

GROUP BY

EVENT_TYPE

UNION ALL

SELECT

EVENT_TYPE,

0 AS Ethereum_Sales,

0 AS Ethereum_Fees_USD,

COUNT(EVENT_TYPE) AS Optimism_Sales,

SUM(total_fees_usd) AS Optimism_Fees_USD,

0 AS Polygon_Sales,

0 AS Polygon_Fees_USD

FROM

optimism.core.ez_nft_sales

WHERE