110,537
社区成员
发帖
与我相关
我的任务
分享
select t1.玩家,胜利局数,失败局数,(胜利局数+失败局数) as 总局数 from
(select 玩家,COUNT(结果) as 胜利局数 from PlayRst where 结果='胜利' group by 玩家)t1
join
(select 玩家,COUNT(结果) as 失败局数 from PlayRst where 结果='失败' group by 玩家)t2
on t1.玩家 = t2.玩家