Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
group for team members and winners in sql-server
with test as ( select 'X' team,'Andy' Name, 1 Won union all select 'X','Cara',1 union all select 'X','Cara',1 union all select 'X','Eric',0 union all select 'X','Eric',0 union all select 'X','Eric',0 union all select 'X','Eric',0 union all select 'Y','Bill',0 union all select 'Y','Dave',0 union all select 'Y','Dave',1 union all select 'Y','Dave',1 ) select team, count(distinct Name) as Players, sum(won) Winners from (select distinct * from test) tst group by team
run
|
edit
|
history
|
help
0
Exam_2_Final
SQL - Find series of timestamps with small gaps
practice sql_12AUG_Upddated
TUAN 7_QUAN LY DE TAI
t1
Many-to-Many Join Example
code
Using Variables
MC170402209
2021-03-06_LeetCodeSQL