where label_type = 'games')

select

label as platforms,

count(distinct FROM_ADDRESS) as address,

count(distinct tx_hash) as transactions

from ronin.core.fact_transactions a join games b on a.to_address = b.address

where block_timestamp::date >= '2025-01-01'

group by 1

order by 3 desc

limit 10