求教sql

泠冷

SELECT channel,game_id,count(*) AS more_positive_user FROM (
SELECT channel,game_id, user_id FROM netgame_platform_log_login_user WHERE date='2014-12-30'
GROUP BY channel,game_id, user_id HAVING count(*)>=5
) AS a GROUP BY channel,game_id；


新人求教一个实现上面查询，更加高效简单的语句~

nycle

建议进行细化拆分，逐个分析优化。