(SELECT
distinct PLATFORM_NAME,
'Optimism' as "name",
count(*)
from optimism.core.ez_nft_sales
group by 1 , 2
order by 3 DESC
limit 10)
union
(SELECT
distinct PLATFORM_NAME,
'Ethereum' as "name",
count(*)
from ethereum.core.ez_nft_sales
group by 1 , 2
order by 3 DESC
limit 10)
union
(SELECT
MARKETPLACE ,
'Flow' as "name",
count(*)
from flow.core.ez_nft_sales
group by 1 , 2
order by 3 DESC
limit 10)