SELECT * FROM 1_Kampe WHERE LigaID = '326' AND (Home='Schalke' OR Away='Schalke') 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
2021-07-23 Schalke 1-3 Hamburger SV 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
2021-08-01 Holstein Kiel 0-3 Schalke 0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1   1/-2 4,00 0.00/1 0.00/1 0.00/1 0.00/0
2021-08-13 Schalke 1-1 Aue 4/1 3,50 1.50/2 1.50/2 0.00/1 3.00/1   0/0 0,00 1.00/2 1.00/2 1.00/1 1.00/1
2021-08-21 Regensburg 4-1 Schalke 8/8 2,67 3.00/3 3.00/3 3.00/1 3.00/2   5/1 3,00 1.33/3 1.33/3 0.50/2 3.00/1
2021-08-28 Schalke 3-1 Dusseldorf 6/-2 3,50 1.00/4 1.00/4 0.50/2 1.50/2   6/-1 3,25 1.00/4 1.00/4 0.50/2 1.50/2
2021-09-12 Paderborn 0-1 Schalke 12/8 3,20 2.20/5 2.20/5 2.00/2 2.33/3   9/0 3,60 1.40/5 1.40/5 1.33/3 1.50/2
2021-09-17 Schalke 1-2 Karlsruher SC 10/1 3,17 1.67/6 1.67/6 1.33/3 2.00/3   9/4 2,33 1.50/6 1.50/6 1.67/3 1.33/3
2021-09-25 Hansa Rostock 0-2 Schalke 8/-4 2,86 1.00/7 1.00/7 1.00/3 1.00/4   11/0 3,14 1.43/7 1.43/7 1.00/4 2.00/3
2021-10-03 Schalke 3-0 Ingolstadt 13/2 3,00 1.63/8 1.63/8 1.00/4 2.25/4   6/-14 3,25 0.50/8 0.50/8 0.25/4 0.75/4
2021-10-15 Hannover 0-1 Schalke 7/-5 2,11 1.22/9 1.25/8 1.50/4 1.00/5   16/5 3,00 1.78/9 2.00/8 1.40/5 2.25/4
2021-10-23 Schalke 3-0 SG Dynamo Dresden 17/6 2,80 1.90/10 2.00/8 1.40/5 2.40/5   13/1 2,50 1.30/10 1.13/8 1.80/5 0.80/5
2021-10-29 Heidenheim 1-0 Schalke 12/-5 2,64 1.36/11 1.25/8 1.50/6 1.20/5   20/9 2,82 2.00/11 2.25/8 1.67/6 2.40/5
2021-11-07 Schalke 2-4 Darmstadt 20/8 2,67 1.83/12 2.25/8 1.67/6 2.00/6   27/13 3,42 1.67/12 2.00/8 2.50/6 0.83/6
2021-11-20 Werder Bremen 1-1 Schalke 19/0 2,92 1.46/13 1.38/8 1.33/6 1.57/7   22/6 2,92 1.69/13 1.88/8 1.43/7 2.00/6
2021-11-27 Schalke 5-2 Sandhausen 23/6 2,86 1.64/14 1.63/8 1.43/7 1.86/7   14/-14 3,00 0.86/14 1.00/8 0.29/7 1.43/7
2021-12-04 St. Pauli 2-1 Schalke 34/16 3,47 2.13/15 2.38/8 3.00/7 1.38/8   28/9 3,13 1.73/15 2.00/8 1.63/8 1.86/7
2021-12-10 Schalke 4-1 Nurnberg 29/8 3,13 1.63/16 1.63/8 1.63/8 1.63/8   23/7 2,44 1.69/16 1.63/8 1.89/9 1.43/7
2021-12-18 Hamburger SV 1-1 Schalke 30/13 2,76 1.71/17 1.88/8 1.89/9 1.50/8   33/11 3,24 1.71/17 1.63/8 1.78/9 1.63/8
2022-01-16 Schalke 1-1 Holstein Kiel 34/11 3,17 1.67/18 1.38/8 1.78/9 1.56/9   23/-7 2,94 1.17/18 1.50/8 1.40/10 0.88/8
2022-01-22 Aue 0-5 Schalke 17/-15 2,58 0.79/19 1.00/8 0.80/10 0.78/9   35/11 3,11 1.63/19 1.13/8 1.70/10 1.56/9
2022-02-05 Schalke 2-1 Regensburg 40/16 3,20 1.70/20 1.50/8 1.70/10 1.70/10   39/9 3,45 1.55/20 0.75/8 1.55/11 1.56/9
2022-02-13 Dusseldorf 2-1 Schalke 23/-7 2,52 0.95/21 0.50/8 0.70/10 1.18/11   42/17 3,19 1.76/21 1.88/8 1.82/11 1.70/10
2022-02-18 Schalke 2-0 Paderborn 43/16 3,18 1.68/22 1.75/8 1.82/11 1.55/11   38/10 3,00 1.45/22 0.88/8 0.83/12 2.20/10
2022-02-26 Karlsruher SC 1-1 Schalke 40/5 3,26 1.39/23 1.38/8 1.58/12 1.18/11   45/18 3,13 1.74/23 1.75/8 1.92/12 1.55/11
2022-03-05 Schalke 3-4 Hansa Rostock 46/18 3,08 1.71/24 1.88/8 1.92/12 1.50/12   27/-11 2,71 1.04/24 0.75/8 0.75/12 1.33/12
2022-03-13 Ingolstadt 0-3 Schalke 22/-26 2,80 0.60/25 1.00/8 0.58/12 0.62/13   49/17 3,24 1.64/25 1.50/8 1.77/13 1.50/12
2022-03-19 Schalke 2-1 Hannover 52/20 3,23 1.69/26 1.75/8 1.77/13 1.62/13   24/-14 2,38 1.19/26 1.38/8 1.23/13 1.15/13
2022-04-01 SG Dynamo Dresden 1-2 Schalke 26/-10 2,30 1.04/27 0.63/8 1.38/13 0.71/14   54/21 3,22 1.74/27 2.00/8 1.86/14 1.62/13
2022-04-09 Schalke 3-0 Heidenheim 56/22 3,21 1.79/28 2.00/8 1.86/14 1.71/14   37/1 2,61 1.61/28 1.38/8 2.21/14 1.00/14
2022-04-17 Darmstadt 2-5 Schalke 57/19 3,28 1.76/29 1.50/8 1.93/14 1.60/15   59/25 3,21 1.83/29 2.00/8 1.93/15 1.71/14
2022-04-23 Schalke 1-4 Werder Bremen 64/28 3,33 1.87/30 2.38/8 1.93/15 1.80/15   54/15 3,10 1.80/30 1.63/8 1.80/15 1.80/15
2022-04-29 Sandhausen 1-2 Schalke 38/-11 2,81 1.23/31 1.63/8 0.93/15 1.50/16   65/25 3,39 1.81/31 2.00/8 1.81/16 1.80/15
2022-05-07 Schalke 3-2 St. Pauli 67/26 3,38 1.84/32 2.25/8 1.81/16 1.88/16   57/14 3,13 1.69/32 1.25/8 2.13/16 1.25/16
2022-05-15 Nurnberg 1-2 Schalke 48/1 2,88 1.55/33 1.13/8 1.69/16 1.41/17   70/27 3,42 1.88/33 2.63/8 1.88/17 1.88/16