אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
||
| שורה 29: | שורה 29: | ||
COUNT(*)=Total Games, | COUNT(*)=Total Games, | ||
COUNT(CASE WHEN fg.Technical=-1 AND ge.Team=1 AND ge.EventType=3 AND ge.SubType!=33 THEN 1 ELSE NULL END)=Total Goals, | COUNT(CASE WHEN fg.Technical=-1 AND ge.Team=1 AND ge.EventType=3 AND ge.SubType!=33 THEN 1 ELSE NULL END)=Total Goals, | ||
COUNT(CASE WHEN ge.SubType=35 AND | COUNT(CASE WHEN ge.SubType=35 AND ge.Team=1 THEN 1 ELSE NULL END)=Penalty Goals, | ||
COUNT(CASE WHEN ge.EventType=4 AND ge.Team=1 THEN 1 ELSE NULL END)=Assists, | COUNT(CASE WHEN ge.EventType=4 AND ge.Team=1 THEN 1 ELSE NULL END)=Assists, | ||
SUM(ResultOpponent)=Total Opponent Goals, | SUM(ResultOpponent)=Total Opponent Goals, | ||
COUNT(CASE WHEN ge.SubType=35 AND | COUNT(CASE WHEN ge.SubType=35 AND ge.Team=2 THEN 1 ELSE NULL END)=Total Opponent Penalty Goals, | ||
COUNT(CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals, | COUNT(CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals, | ||
COUNT(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card, | COUNT(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card, | ||