SELECT address, label_type, project_name

FROM Kaia.core.dim_labels

WHERE label_type = 'dapp'

),

dapps AS (

SELECT

tx_hash,

from_address,

to_address

FROM Kaia.core.fact_transactions

WHERE to_address IN (SELECT address FROM game_addresses)

SELECT

g.project_name,

COUNT(DISTINCT d.tx_hash) AS total_dapp_tx,

COUNT(DISTINCT d.from_address) AS total_dapp_users

FROM dapps d

JOIN game_addresses g ON d.to_address = g.address

GROUP BY g.project_name

ORDER BY total_dapp_tx DESC

LIMIT 10;