platform_name,

transaction_count,

'BNB Chain' AS chain

FROM (

SELECT

platform_name,

COUNT(*) AS transaction_count

FROM

bsc.nft.ez_nft_sales -- Adjust the table name according to your schema

WHERE

block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY

platform_name

ORDER BY

transaction_count DESC

LIMIT 10 -- Limit to top 10 platforms

) AS bnb_platforms

UNION ALL

platform_name,

transaction_count,

'Avalanche' AS chain

FROM (

SELECT

platform_name,

COUNT(*) AS transaction_count

FROM

avalanche.nft.ez_nft_sales -- Adjust the table name according to your schema

WHERE

block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'

GROUP BY