AI Assist is now on Stack Overflow. Start a chat to get instant answers from across the network. Sign up to save and share your chats.

1. Home
2. Questions
3. AI Assist
4. Tags
6. Challenges
7. Chat
8. Articles
9. Users
11. Jobs
12. Companies
13. Collectives
14. Communities for your favorite technologies. Explore all Collectives
Stack Internal

Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work.
Try for free Learn more
Stack Internal
Bring the best of human thought and AI automation together at your work. Learn more

Return to Answer

added 57 characters in body

edited Mar 25, 2017 at 17:27

Carsten Massmann

28.4k
3
25
49

Try this:

select team, count(distinct Name) as Players, sum(won) Winners from (select distinct * from test) tst group by team

You can test it here: http://rextester.com/QATLK24197

Try this:

select team, count(distinct Name) as Players, sum(won) Winners from (select distinct * from test) tst group by team

Try this:

select team, count(distinct Name) as Players, sum(won) Winners from (select distinct * from test) tst group by team

You can test it here: http://rextester.com/QATLK24197

answered Mar 25, 2017 at 17:15

Carsten Massmann

28.4k
3
25
49

Try this:

select team, count(distinct Name) as Players, sum(won) Winners from (select distinct * from test) tst group by team