(Don't count first and second yellows) |
אין תקציר עריכה |
||
| שורה 37: | שורה 37: | ||
SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | ||
SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | ||
SUM(CASE when Games_Events.SubType | SUM(CASE when Games_Events.SubType=71 then 1 else 0 end)=YellowCards, | ||
SUM(CASE when Games_Events.SubType | SUM(CASE when Games_Events.SubType IN (72,73) then 1 else 0 end)=RedCards, | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=1 then 1 else 0 end)=Wins, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=1 then 1 else 0 end)=Wins, | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties, | ||
| שורה 78: | שורה 78: | ||
SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | ||
SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | SUM(CASE when Games_Events.EventType=4 then 1 else 0 end)=Assists, | ||
SUM(CASE when Games_Events.SubType | SUM(CASE when Games_Events.SubType=71 then 1 else 0 end)=YellowCards, | ||
SUM(CASE when Games_Events.SubType | SUM(CASE when Games_Events.SubType IN (72,73) then 1 else 0 end)=RedCards, | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=1 then 1 else 0 end)=Wins, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=1 then 1 else 0 end)=Wins, | ||
SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties, | SUM(CASE when Games_Events.EventType IN (1,5) AND Football_Games.ResultOpt=2 then 1 else 0 end)=Ties, | ||