SELECT * FROM 1_Kampe WHERE LigaID = '227' AND (Home='Brann' OR Away='Brann') ORDER BY Dato ASC;
Dato Home Score Away H Goals/Dif A Goals Av. H Avp/M H Avp Last/M H Avp Home/M H Avp Away/M   A Goals/Dif A Goals Av. A Avp/M A Avp Last/M A Avp Home/M A Avp Away/M
2020-04-05 Rosenborg - Brann / /0 / / /   / /0 / / /
2020-04-13 Brann - Stabaek / /0 / / /   / /0 / / /
2020-04-19 Sandefjord - Brann / /0 / / /   / /0 / / /
2020-04-25 Brann - Bodo/Glimt / /0 / / /   / /0 / / /
2020-05-03 Brann - Kristiansund / /0 / / /   / /0 / / /
2020-05-10 Mjondalen - Brann / /0 / / /   / /0 / / /
2020-05-16 Brann - Haugesund / /0 / / /   / /0 / / /
2020-06-17 Haugesund 1-2 Brann 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2020-06-21 Brann 3-0 Viking 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   2/-2 6,00 0.00/1 0.00/1 0.00/1 0.00/0
2020-06-24 Aalesund 2-2 Brann 3/-8 7,00 0.00/2 0.00/2 0.00/1 0.00/1   5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1
2020-06-28 Brann 1-2 Rosenborg 7/4 3,33 2.33/3 2.33/3 3.00/1 2.00/2   2/-2 2,00 0.33/3 0.33/3 0.50/2 0.00/1
2020-07-02 Sarpsborg 08 0-1 Brann 3/-4 2,50 0.00/4 0.00/4 0.00/2 0.00/2   8/3 3,25 1.75/4 1.75/4 1.50/2 2.00/2
2020-07-05 Bodo/Glimt 5-0 Brann 19/13 5,00 3.00/5 3.00/5 3.00/2 3.00/3   9/4 2,80 2.00/5 2.00/5 1.50/2 2.33/3
2020-07-12 Brann 3-1 Sandefjord 9/-1 3,17 1.67/6 1.67/6 1.50/2 1.75/4   4/-7 2,50 0.67/6 0.67/6 0.33/3 1.00/3
2020-07-15 Odd 1-0 Brann 12/3 3,00 1.43/7 1.43/7 1.00/4 2.00/3   12/1 3,29 1.86/7 1.86/7 2.00/3 1.75/4
2020-07-19 Brann 1-1 Start 12/0 3,00 1.63/8 1.63/8 2.00/3 1.40/5   7/-8 2,75 0.50/8 0.50/8 0.60/5 0.33/3
2020-07-25 Brann 1-1 Kristiansund 13/0 2,89 1.56/9 1.38/8 1.75/4 1.40/5   17/4 3,33 1.22/9 1.25/8 1.25/4 1.20/5
2020-07-29 Stromsgodset 3-1 Brann 11/-8 3,00 1.20/10 1.00/8 1.60/5 0.80/5   14/0 2,80 1.50/10 1.13/8 1.60/5 1.40/5
2020-08-01 Brann 1-2 Valerenga 15/-2 2,91 1.36/11 1.00/8 1.60/5 1.17/6   14/0 2,55 1.73/11 1.88/8 2.20/5 1.33/6
2020-08-10 Molde 1-2 Brann 39/26 4,00 2.38/13 2.25/8 3.00/6 1.86/7   16/-3 2,92 1.25/12 1.00/8 1.33/6 1.17/6
2020-08-16 Brann 0-1 Mjondalen 18/-2 2,92 1.38/13 1.00/8 1.33/6 1.43/7   11/-7 2,23 0.85/13 0.38/8 1.00/6 0.71/7
2020-08-24 Stabaek 0-2 Brann 19/-2 2,86 1.29/14 1.25/8 1.29/7 1.29/7   18/-3 2,79 1.29/14 1.00/8 1.14/7 1.43/7
2020-08-29 Brann 1-1 Stromsgodset 20/-1 2,73 1.40/15 1.00/8 1.14/7 1.63/8   22/-9 3,53 1.20/15 1.13/8 1.38/8 1.00/7
2020-09-13 Valerenga 5-1 Brann 22/0 2,75 1.63/16 1.38/8 2.14/7 1.22/9   21/-1 2,69 1.38/16 1.13/8 1.13/8 1.63/8
2020-09-20 Brann 1-3 Bodo/Glimt 22/-5 2,88 1.29/17 1.00/8 1.13/8 1.44/9   62/43 4,76 2.76/17 2.50/8 3.00/8 2.56/9
2020-09-27 Kristiansund 1-1 Brann 38/11 3,61 1.67/18 2.25/8 1.75/8 1.60/10   23/-7 2,94 1.22/18 0.88/8 1.00/9 1.44/9
2020-10-04 Brann 1-2 Molde 24/-7 2,89 1.21/19 1.00/8 1.00/9 1.40/10   46/23 3,63 1.79/19 0.75/8 2.33/9 1.30/10
2020-10-17 Mjondalen 2-0 Brann 15/-21 2,55 0.70/20 0.75/8 0.67/9 0.73/11   25/-8 2,90 1.15/20 1.00/8 0.90/10 1.40/10
2020-10-24 Brann 1-1 Stabaek 25/-10 2,86 1.10/21 0.63/8 0.90/10 1.27/11   29/-3 2,90 1.33/21 1.38/8 1.64/11 1.00/10
2020-11-01 Sandefjord 3-3 Brann 22/-12 2,55 1.18/22 1.25/8 1.10/10 1.25/12   26/-10 2,82 1.09/22 0.75/8 0.91/11 1.27/11
2020-11-07 Brann 1-2 Haugesund 29/-10 2,96 1.09/23 0.50/8 0.91/11 1.25/12   27/-10 2,78 1.22/23 1.25/8 1.42/12 1.00/11
2020-11-24 Rosenborg 2-3 Brann 43/18 2,83 1.88/24 2.13/8 2.25/12 1.50/12   30/-11 2,96 1.04/24 0.38/8 0.83/12 1.25/12
2020-11-28 Brann 3-1 Aalesund 33/-10 3,04 1.12/25 0.75/8 0.83/12 1.38/13   27/-45 3,96 0.44/25 0.50/8 0.46/13 0.42/12
2020-12-02 Viking 2-0 Brann 48/3 3,58 1.50/26 1.75/8 1.62/13 1.38/13   36/-8 3,08 1.19/26 1.13/8 1.00/13 1.38/13
2020-12-06 Brann 1-1 Sarpsborg 08 36/-10 3,04 1.15/27 1.00/8 1.00/13 1.29/14   32/-5 2,56 1.11/27 0.75/8 1.43/14 0.77/13
2020-12-09 Start 1-1 Brann 32/-19 2,96 0.93/28 1.00/8 1.43/14 0.43/14   37/-10 3,00 1.14/28 1.13/8 1.00/14 1.29/14
2020-12-22 Brann 2-1 Odd 38/-10 2,97 1.14/29 1.25/8 1.00/14 1.27/15   51/2 3,45 1.48/29 0.63/8 1.73/15 1.21/14