SQL每日一题(20201125)anum表示每个人参加的项目数，bnum表示每个人在各自项目中胜利的次数

SQL每日一题(20220601)
SQL每日一题(20220711)

SELECT B,
       COUNT(1)                                                                                   anum,
       ifnull((SELECT SUM(CASE WHEN C = '胜' THEN 1 ELSE 0 END) FROM T1125B b WHERE a.B = b.B), 0) bnum
FROM T1125A a
GROUP BY b

select a.B, count(a.A) anum, sum(case when b.C = '胜' then 1 else 0 end) bnum
from T1125A a
         left join T1125B b on a.A = b.A and a.B = b.B
GROUP BY a.B