SELECT address, label_type

FROM Kaia.core.dim_labels

WHERE label_type = 'games'

),

dapps AS (

SELECT

DATE(block_timestamp) AS date,

tx_hash,

from_address,

to_address

FROM Kaia.core.fact_transactions

WHERE to_address IN (SELECT address FROM game_addresses)

SELECT

COUNT(DISTINCT d.tx_hash) AS total_tx,

COUNT(DISTINCT d.from_address) AS total_users

FROM dapps d

JOIN game_addresses g ON d.to_address = g.address;