使用这些数据
Team Name Won
X Andy 1
X Cara 1
X Cara 1
X Eric 0
X Eric 0
X Eric 0
X Eric 0
Y Bill 0
Y Dave 0
Y Dave 1
Y Dave 1
我希望你能为每个团队提供参赛人数和获胜者数量的翻译。
Team Players Winners
X 3 2
Y 2 1
它用两个查询来完成:
select team, count(distinct Name) as Players from test group by team
select team, count(distinct Name) as Winners from test where Won=1 group by team
但是我无法想出在一行中完成它的语法。谢谢你的帮助。 John