אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה תגית: שוחזרה |
אורן המתעפץ (שיחה | תרומות) אין תקציר עריכה תגית: שוחזרה |
||
| שורה 31: | שורה 31: | ||
COUNT(CASE WHEN ge.SubType=35 AND ge.Team=1 THEN 1 ELSE NULL END)=Penalty Goals, | 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(fg.ResultOpponent * (ge._rowID = 1)) | SUM(fg.ResultOpponent * (ge._rowID = 1)) =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(CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals, | ||