如何统计所有玩家的连输局数

[lbmjsls1]

上一个问题 https://www.v2ex.com/t/749062 解决了，统计所有玩家的想不出来。用了 group by，各种不对。

[chotow]

select g1.userid, count(if(g1.score < 0, 1, null)) as ret
from game as g1
left join game as g2 on g2.userid = g1.userid and g2.score > 0 and g2.id > g1.id
where g2.id is null
group by g1.userid

[lbmjsls1]

@chotow 多谢，测试下来是正确的。看了半天才看懂。

[xing7673]

就喜欢这种二话不说拍代码的硬核老哥

[q9OxQg]

连我这非 IT 人士都给一楼点了个赞，并读了代码。