SELECT * FROM 1_Kampe WHERE LigaID = '2' AND (Home='Norwich' OR Away='Norwich') 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
2019-08-09 Liverpool 4-1 Norwich 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
2019-08-17 Norwich 3-1 Newcastle 1/-3 5,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2019-08-24 Norwich 2-3 Chelsea 4/-1 4,50 1.50/2 1.50/2 3.00/1 0.00/1   1/-4 3,00 0.50/2 0.50/2 1.00/1 0.00/1
2019-08-31 West Ham 2-0 Norwich 4/-3 3,67 1.33/3 1.33/3 0.00/1 2.00/2   6/-2 4,67 1.00/3 1.00/3 1.50/2 0.00/1
2019-09-14 Norwich 3-2 Manchester City 6/-4 4,00 0.75/4 0.75/4 1.50/2 0.00/2   14/11 4,25 2.50/4 2.50/4 2.00/2 3.00/2
2019-09-21 Burnley 2-0 Norwich 6/-1 2,60 1.00/5 1.00/5 1.50/2 0.67/3   9/-3 4,20 1.20/5 1.20/5 2.00/3 0.00/2
2019-09-28 Crystal Palace 2-0 Norwich 4/-3 1,83 1.33/6 1.33/6 1.67/3 1.00/3   9/-5 3,83 1.00/6 1.00/6 2.00/3 0.00/3
2019-10-05 Norwich 1-5 Aston Villa 9/-7 3,57 0.86/7 0.86/7 2.00/3 0.00/4   8/-3 2,71 0.71/7 0.71/7 1.25/4 0.00/3
2019-10-19 Bournemouth 0-0 Norwich 13/0 3,25 1.38/8 1.38/8 1.25/4 1.50/4   10/-11 3,88 0.75/8 0.75/8 1.50/4 0.00/4
2019-10-27 Norwich 1-3 Manchester Utd 10/-11 3,44 0.78/9 0.88/8 1.50/4 0.20/5   10/1 2,11 1.11/9 0.88/8 1.60/5 0.50/4
2019-11-02 Brighton 2-0 Norwich 12/-2 2,60 1.20/10 1.00/8 1.60/5 0.80/5   11/-13 3,50 0.70/10 0.50/8 1.20/5 0.20/5
2019-11-08 Norwich 0-2 Watford 11/-15 3,36 0.64/11 0.50/8 1.20/5 0.17/6   6/-17 2,64 0.45/11 0.63/8 0.50/6 0.40/5
2019-11-23 Everton 0-2 Norwich 13/-5 2,58 1.17/12 0.88/8 1.67/6 0.67/6   11/-17 3,25 0.58/12 0.50/8 1.00/6 0.17/6
2019-12-01 Norwich 2-2 Arsenal 13/-15 3,15 0.77/13 0.50/8 1.00/6 0.57/7   18/-1 2,85 1.38/13 1.25/8 1.86/7 0.83/6
2019-12-04 Southampton 2-1 Norwich 15/-17 3,36 0.86/14 0.63/8 0.57/7 1.14/7   15/-15 3,21 0.79/14 0.63/8 1.00/7 0.57/7
2019-12-08 Norwich 1-2 Sheffield Utd 16/-16 3,20 0.73/15 0.63/8 1.00/7 0.50/8   17/2 2,13 1.27/15 1.38/8 1.25/8 1.29/7
2019-12-14 Leicester 1-1 Norwich 39/29 3,06 2.38/16 3.00/8 2.75/8 2.00/8   17/-17 3,19 0.69/16 0.63/8 0.88/8 0.50/8
2019-12-21 Norwich 1-2 Wolves 18/-17 3,12 0.71/17 0.63/8 0.88/8 0.56/9   24/3 2,65 1.41/17 1.63/8 1.44/9 1.38/8
2019-12-26 Aston Villa 1-0 Norwich 24/-9 3,17 0.83/18 0.50/8 1.22/9 0.44/9   19/-18 3,11 0.67/18 0.63/8 0.78/9 0.56/9
2019-12-28 Norwich 2-2 Tottenham 19/-19 3,00 0.63/19 0.63/8 0.78/9 0.50/10   34/7 3,21 1.53/19 2.00/8 2.00/10 1.00/9
2020-01-01 Norwich 1-1 Crystal Palace 21/-19 3,05 0.65/20 0.75/8 0.80/10 0.50/10   18/-4 2,00 1.35/20 1.50/8 1.50/10 1.20/10
2020-01-11 Manchester Utd 4-0 Norwich 32/7 2,71 1.48/21 1.75/8 1.90/10 1.09/11   22/-19 3,00 0.67/21 0.50/8 0.82/11 0.50/10
2020-01-18 Norwich 1-0 Bournemouth 22/-23 3,05 0.64/22 0.38/8 0.82/11 0.45/11   20/-15 2,50 0.91/22 0.50/8 0.91/11 0.91/11
2020-01-22 Tottenham 2-1 Norwich 36/5 2,91 1.35/23 1.38/8 1.82/11 0.92/12   23/-22 2,96 0.74/23 0.75/8 1.00/12 0.45/11
2020-02-01 Newcastle 0-0 Norwich 24/-12 2,50 1.25/24 1.00/8 1.58/12 0.92/12   24/-23 2,96 0.71/24 0.75/8 1.00/12 0.42/12
2020-02-15 Norwich 0-1 Liverpool 24/-23 2,84 0.72/25 0.75/8 1.00/12 0.46/13   60/45 3,00 2.92/25 3.00/8 3.00/13 2.83/12
2020-02-23 Wolves 3-0 Norwich 35/3 2,58 1.38/26 1.13/8 1.38/13 1.38/13   24/-24 2,77 0.69/26 0.75/8 0.92/13 0.46/13
2020-02-28 Norwich 1-0 Leicester 24/-27 2,78 0.67/27 0.75/8 0.92/13 0.43/14   54/27 3,00 1.85/27 1.38/8 1.93/14 1.77/13
2020-03-07 Sheffield Utd 1-0 Norwich 29/4 2,00 1.48/27 1.38/8 1.50/14 1.46/13   25/-26 2,71 0.75/28 1.00/8 1.07/14 0.43/14
2020-06-19 Norwich 0-3 Southampton 25/-27 2,66 0.72/29 0.88/8 1.07/14 0.40/15   35/-17 3,00 1.17/29 1.13/8 0.93/15 1.43/14
2020-06-24 Norwich 0-1 Everton 25/-30 2,67 0.70/30 0.88/8 1.00/15 0.40/15   37/-9 2,77 1.27/30 1.25/8 1.73/15 0.80/15
2020-07-01 Arsenal 4-0 Norwich 43/2 2,71 1.39/31 1.75/8 1.73/15 1.06/16   25/-31 2,61 0.68/31 0.50/8 0.94/16 0.40/15
2020-07-04 Norwich 0-1 Brighton 25/-35 2,66 0.66/32 0.50/8 0.94/16 0.38/16   34/-10 2,44 1.03/32 1.00/8 1.31/16 0.75/16
2020-07-07 Watford 2-1 Norwich 29/-23 2,45 0.85/33 0.63/8 1.13/16 0.59/17   25/-36 2,61 0.64/33 0.38/8 0.88/17 0.38/16
2020-07-11 Norwich 0-4 West Ham 26/-37 2,62 0.62/34 0.38/8 0.88/17 0.35/17   40/-19 2,91 0.91/34 0.88/8 1.06/17 0.76/17
2020-07-14 Chelsea 1-0 Norwich 63/14 3,20 1.71/35 2.00/8 1.76/17 1.67/18   26/-41 2,66 0.60/35 0.38/8 0.83/18 0.35/17
2020-07-18 Norwich 0-2 Burnley 26/-42 2,61 0.58/36 0.00/8 0.83/18 0.33/18   40/-8 2,44 1.42/36 1.63/8 1.56/18 1.28/18
2020-07-26 Manchester City 5-0 Norwich 97/62 3,57 2.11/37 2.25/8 2.44/18 1.79/19   26/-44 2,59 0.57/37 0.00/8 0.79/19 0.33/18