SELECT DISTINCT from_address, MIN(DATE_TRUNC('month', block_timestamp)) AS first_tx_month

FROM Kaia.core.fact_transactions

GROUP BY from_address

HAVING MIN(DATE_TRUNC('month', block_timestamp)) >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '6 months'

),

game_usage AS (

SELECT

t.from_address,

d.project_name,

DATE_TRUNC('month', t.block_timestamp) AS usage_month

FROM Kaia.core.fact_transactions t

JOIN Kaia.core.dim_labels d ON t.to_address = d.address

WHERE d.label_type = 'games'

AND t.from_address IN (SELECT from_address FROM kaia_new_users)

SELECT

u.project_name AS "Game Project",

COUNT(DISTINCT u.from_address) AS "New Users"

FROM game_usage u

GROUP BY u.project_name

ORDER BY COUNT(DISTINCT u.from_address) DESC

LIMIT 5;