BergensBowl

SELECT DISTINCT ROUND((CAST(Score-OppScore AS SIGNED)/Matches),2) AS Col, Matches, Fullname, Coach_Id, TEAM.Id AS Team_Id FROM HOF_TEAM_STATS, TEAM, USER, PLAYER, PLAYER_TYPE WHERE HOF_TEAM_STATS.Team_Id=USER.Id AND Matches>=5 AND TEAM.Coach_Id=USER.Id AND TEAM.Id=PLAYER.Team_Id AND PLAYER_TYPE.Id=PLAYER.Player_Type_Id AND PLAYER.Status>0 GROUP BY USER.Id ORDER BY Col DESC, Matches DESC LIMIT 10 SELECT DISTINCT ROUND((Cast(HOF_TEAM_STATS.Cas-HOF_TEAM_STATS.OppCas AS SIGNED)/Matches),2) AS Col, Matches, Fullname, Coach_Id, TEAM.Id AS Team_Id FROM HOF_TEAM_STATS, TEAM, USER, PLAYER, PLAYER_TYPE WHERE HOF_TEAM_STATS.Team_Id=USER.Id AND Matches>=5 AND TEAM.Coach_Id=USER.Id AND TEAM.Id=PLAYER.Team_Id AND PLAYER_TYPE.Id=PLAYER.Player_Type_Id AND PLAYER.Status>0 GROUP BY USER.Id ORDER BY Col DESC, Matches DESC LIMIT 10

Most winning coach

Win ratio (%)CoachMatches
81Erlend Stunner18
66Bjørnar Langeland48
65Jan Bjørvik26
63Rune Berge233
61Lars Olai177
61John9
59Ronny Tømmerbakke189
57Johan Tavast53
56Frank Wisnes16
54BÃ¥rd Eggen24

Most scoring coach

Avg. scoreCoachMatches
2.41Lars Olai177
2.38Frank Wisnes16
2.17Bjørnar Langeland48
2.11Erlend Stunner18
2.08BÃ¥rd Eggen24
2.07Rune Berge233
2.06Johan Tavast53
2.00Rachel Tavast6
1.76Joakim29
1.74Fredrik T Larssen31

Best defensive coach

Avg. opp. scoreCoachMatches
0.83Erlend Stunner18
1.19Jan Bjørvik26
1.22John9
1.40Ronny Tømmerbakke189
1.46Bjørnar Langeland48
1.50Steinar22
1.56Rune Berge233
1.63Lars Olai177
1.64Jan Inge Øvrebø33
1.67Dan Oldfield9

Best goal difference

Avg. goal diff.CoachMatches

Most violent coach

Avg. casualtiesCoachMatches
3.11John9
3.09Steinar22
2.97Knut S.Helland32
2.48Fredrik T Larssen31
2.40Sigurd Garshol5
2.39Erlend Stunner18
2.37Ronny Tømmerbakke189
2.33Rachel Tavast6
2.32Trygve M Pettersen187
2.22Simon9

Least injured coach

Avg. opp. cas.CoachMatches
0.40Bjørn5
0.83Erlend Stunner18
0.83Karin6
0.88Jan Bjørvik26
1.26Fredrik T Larssen31
1.33Jan Inge Øvrebø33
1.45Steinar22
1.50Lasse Jørgensen24
1.54Bjørnar Langeland48
1.54BÃ¥rd Eggen24

Best casualty difference

Avg. cas. diff.CoachMatches