题解 | 游戏平台新玩家消费与进阶行为分析

把高阶玩家打成高级玩家了 找半天错 服了

select player_id,username,level current_level,
if(level>=30,'高阶玩家','新秀玩家') player_category,
round(sum(cost),2) total_april_spending
from (
    select p.player_id,username,level,creation_date,transaction_id,item_name,cost,purchase_time
    from players p join transactions t on p.player_id = t.player_id 
    and creation_date like '2025-03%' and purchase_time like '2025-04%'
) t1 
group by player_id,username,level
order by player_category desc,total_april_spending desc,player_id