select

distinct event_name,

CASE

-- Gaming Activity

-- Includes general in-game interactions such as daily logins, battles, and quests.

-- These events represent a high user count (`N_USERS`) and frequent transactions (`N_TXNS`).

WHEN event_name IN ('DailyLogDone', 'Fire', 'RaffleCheckin', 'DailyCheckin', 'StreakUpdated', 'BoughtEnergy', 'AxieEvolved', 'playedGacha', 'batchPlayedGacha') THEN 'Gaming Activity'

-- Item Trading

-- Covers the minting, trading, and burning of in-game assets.

-- Data shows a substantial number of transactions related to NFT/game asset exchanges.

WHEN event_name IN ('Mint', 'Trade', 'Burn', 'Purchase', 'Sell', 'Swap', 'TokenCreated', 'Burned') THEN 'Item Trading'

-- Token (Staking, Rewards)

-- Includes financial incentives such as staking rewards and liquidity provisions.

-- These events exhibit relatively high transaction volume but a lower unique user count compared to gaming activity.

WHEN event_name IN ('Staking', 'Unstaking', 'RewardsClaimed', 'Claim', 'RewardClaimed', 'Farming', 'Liquidity Provision', 'CoreStaked', 'CoreUnstaked', 'Delegated', 'Staked', 'Unstaked') THEN 'Token (Staking, Rewards)'

-- Asset Transfer

-- Represents wallet-to-wallet transactions, approvals, deposits, and withdrawals.

-- High transaction count but may involve fewer unique users compared to gameplay activities.

WHEN event_name IN ('Transfer', 'Deposit', 'Withdraw', 'CCIPSendRequested', 'Withdrawal', 'SafeReceived') THEN 'Asset Transfer'

-- Social & Guild Interactions

-- Captures community-driven activities such as joining guilds, making friends, and leaderboard updates.

-- Moderate transaction count but strong user engagement, crucial for multiplayer experiences.

WHEN event_name IN ('GuildJoin', 'GuildCreate', 'FriendRequest', 'LeaderboardUpdate',

'ReferralUpdated', 'ReferralAdded', 'ReferralRemoved', 'ProfileAdded',

'ProfileAddressChanged', 'VotedToBless', 'VotedToCurse', 'UnvotedToCurse') THEN 'Social & Guild Interactions'

-- Quest & Battle Participation