WITH nft_sales AS
(SELECT *
FROM ethereum.core.ez_nft_sales
WHERE block_timestamp::date >= CURRENT_DATE() - INTERVAL '3 month'
),
nft_trx AS
(SELECT *
FROM ethereum.core.fact_transactions
WHERE to_address IN (SELECT DISTINCT(platform_address) FROM ethereum.core.ez_nft_sales)
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '3 month'
),
combined AS
(SELECT trx.block_timestamp,
trx.tx_hash,
trx.from_address,
trx.status,
sales.platform_name
FROM nft_trx trx
JOIN nft_sales sales
ON trx.to_address = sales.platform_address
WHERE trx.status ='SUCCESS')
SELECT
COUNT(tx_hash) AS "Transactions",
platform_name
FROM combined
GROUP BY platform_name