אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה תגית: שוחזרה |
||
| שורה 33: | שורה 33: | ||
SUM(ResultOpponent)=Total Opponent Goals, | SUM(ResultOpponent)=Total Opponent Goals, | ||
COUNT(CASE WHEN ge.SubType=35 AND ge.Team=0 THEN 1 ELSE NULL END)=Total Opponent Penalty Goals, | COUNT(CASE WHEN ge.SubType=35 AND ge.Team=0 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(DISTINCT 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, | ||
COUNT(CASE WHEN ge.SubType=72 AND ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card, | COUNT(CASE WHEN ge.SubType=72 AND ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card, | ||