SELECT nft_address,

SUM(price_usd) AS "sales in USD"

FROM ethereum.core.ez_nft_sales

WHERE DATE_TRUNC('week',block_timestamp) BETWEEN '2023-01-01' AND '2023-08-31'

AND currency_symbol IN ('ETH', 'WETH')

GROUP BY nft_address

QUALIFY ROW_NUMBER() OVER (ORDER BY "sales in USD" DESC) <= 10

)

SELECT DATE_TRUNC('week',block_timestamp) AS "week",

COALESCE(lower(aggregator_name), platform_name) AS platform,

SUM(price_usd) AS "sales in USD"

FROM ethereum.core.ez_nft_sales

WHERE DATE_TRUNC('week', block_timestamp) >= '2023-01-01'

AND platform IN ('opensea', 'blur', 'looksrare')

AND currency_symbol IN ('ETH', 'WETH')

AND nft_address IN (

SELECT nft_address

FROM address

)

GROUP BY "week", platform

ORDER BY "week"