Step 1: Select rows where the 'date' is in September.
date |
opponent |
score |
loss |
attendance |
record |
9999-09-01 |
mets |
3 - 0 |
hentgen (14 - 9) |
19196 |
65 - 71 |
9999-09-02 |
mets |
8 - 5 |
clemens (20 - 5) |
17635 |
65 - 72 |
9999-09-03 |
mets |
4 - 2 |
quantrill (6 - 6) |
14513 |
65 - 73 |
9999-09-04 |
rangers |
6 - 2 |
carpenter (1 - 7) |
26178 |
65 - 74 |
9999-09-05 |
rangers |
5 - 1 |
pavlik (2 - 4) |
27121 |
66 - 74 |
9999-09-06 |
rangers |
2 - 1 |
burkett (7 - 12) |
31232 |
67 - 74 |
9999-09-07 |
rangers |
4 - 0 |
oliver (11 - 11) |
30212 |
68 - 74 |
9999-09-08 |
angels |
12 - 10 |
james (4 - 5) |
25775 |
69 - 74 |
9999-09-09 |
angels |
2 - 0 |
hill (7 - 12) |
25674 |
70 - 74 |
9999-09-10 |
athletics |
3 - 2 |
plesac (1 - 4) |
4764 |
70 - 75 |
9999-09-11 |
athletics |
8 - 7 |
escobar (2 - 1) |
6135 |
70 - 76 |
9999-09-12 |
mariners |
7 - 3 |
clemens (21 - 6) |
37044 |
70 - 77 |
9999-09-13 |
mariners |
6 - 3 |
ayala (10 - 5) |
51631 |
71 - 77 |
9999-09-14 |
mariners |
3 - 2 |
risley (0 - 1) |
45477 |
71 - 78 |
9999-09-15 |
mariners |
7 - 3 |
williams (8 - 14) |
41684 |
71 - 79 |
9999-09-17 |
red sox |
4 - 3 |
quantrill (6 - 7) |
23648 |
71 - 80 |
9999-09-18 |
red sox |
3 - 2 |
escobar (3 - 2) |
27990 |
71 - 81 |
9999-09-19 |
yankees |
3 - 0 |
gooden (8 - 5) |
31195 |
72 - 81 |
9999-09-20 |
yankees |
4 - 3 (11) |
janzen (1 - 1) |
38332 |
72 - 82 |
9999-09-21 |
yankees |
5 - 4 (10) |
almanzar (0 - 1) |
40038 |
72 - 83 |
9999-09-22 |
yankees |
8 - 1 |
hentgen (15 - 10) |
23380 |
72 - 84 |
9999-09-23 |
orioles |
3 - 2 |
clemens (21 - 7) |
29276 |
72 - 85 |
9999-09-24 |
orioles |
9 - 3 |
daal (1 - 1) |
27443 |
72 - 86 |
9999-09-25 |
orioles |
4 - 3 |
mussina (15 - 8) |
28324 |
73 - 86 |
9999-09-26 |
red sox |
3 - 0 |
henry (7 - 3) |
34155 |
74 - 86 |
9999-09-27 |
red sox |
12 - 5 |
corsi (5 - 3) |
37401 |
75 - 86 |
9999-09-28 |
red sox |
3 - 2 |
gordon (6 - 10) |
40251 |
76 - 86 |
Step 2: Extract the numerical runs from the 'score' column by identifying the number before '-' to add column 'runs' to existing table.
date |
opponent |
score |
loss |
attendance |
record |
9999-09-01 |
mets |
3 - 0 |
hentgen (14 - 9) |
19196 |
65 - 71 |
9999-09-02 |
mets |
8 - 5 |
clemens (20 - 5) |
17635 |
65 - 72 |
9999-09-03 |
mets |
4 - 2 |
quantrill (6 - 6) |
14513 |
65 - 73 |
9999-09-04 |
rangers |
6 - 2 |
carpenter (1 - 7) |
26178 |
65 - 74 |
9999-09-05 |
rangers |
5 - 1 |
pavlik (2 - 4) |
27121 |
66 - 74 |
9999-09-06 |
rangers |
2 - 1 |
burkett (7 - 12) |
31232 |
67 - 74 |
9999-09-07 |
rangers |
4 - 0 |
oliver (11 - 11) |
30212 |
68 - 74 |
9999-09-08 |
angels |
12 - 10 |
james (4 - 5) |
25775 |
69 - 74 |
9999-09-09 |
angels |
2 - 0 |
hill (7 - 12) |
25674 |
70 - 74 |
9999-09-10 |
athletics |
3 - 2 |
plesac (1 - 4) |
4764 |
70 - 75 |
9999-09-11 |
athletics |
8 - 7 |
escobar (2 - 1) |
6135 |
70 - 76 |
9999-09-12 |
mariners |
7 - 3 |
clemens (21 - 6) |
37044 |
70 - 77 |
9999-09-13 |
mariners |
6 - 3 |
ayala (10 - 5) |
51631 |
71 - 77 |
9999-09-14 |
mariners |
3 - 2 |
risley (0 - 1) |
45477 |
71 - 78 |
9999-09-15 |
mariners |
7 - 3 |
williams (8 - 14) |
41684 |
71 - 79 |
9999-09-17 |
red sox |
4 - 3 |
quantrill (6 - 7) |
23648 |
71 - 80 |
9999-09-18 |
red sox |
3 - 2 |
escobar (3 - 2) |
27990 |
71 - 81 |
9999-09-19 |
yankees |
3 - 0 |
gooden (8 - 5) |
31195 |
72 - 81 |
9999-09-20 |
yankees |
4 - 3 (11) |
janzen (1 - 1) |
38332 |
72 - 82 |
9999-09-21 |
yankees |
5 - 4 (10) |
almanzar (0 - 1) |
40038 |
72 - 83 |
9999-09-22 |
yankees |
8 - 1 |
hentgen (15 - 10) |
23380 |
72 - 84 |
9999-09-23 |
orioles |
3 - 2 |
clemens (21 - 7) |
29276 |
72 - 85 |
9999-09-24 |
orioles |
9 - 3 |
daal (1 - 1) |
27443 |
72 - 86 |
9999-09-25 |
orioles |
4 - 3 |
mussina (15 - 8) |
28324 |
73 - 86 |
9999-09-26 |
red sox |
3 - 0 |
henry (7 - 3) |
34155 |
74 - 86 |
9999-09-27 |
red sox |
12 - 5 |
corsi (5 - 3) |
37401 |
75 - 86 |
9999-09-28 |
red sox |
3 - 2 |
gordon (6 - 10) |
40251 |
76 - 86 |
Step 3: Cast to INT and order the table by 'runs' in ascending order and select the first row.
date |
opponent |
score |
loss |
attendance |
record |
runs |
9999-09-01 |
mets |
3 - 0 |
hentgen (14 - 9) |
19196 |
65 - 71 |
3 |
9999-09-02 |
mets |
8 - 5 |
clemens (20 - 5) |
17635 |
65 - 72 |
8 |
9999-09-03 |
mets |
4 - 2 |
quantrill (6 - 6) |
14513 |
65 - 73 |
4 |
9999-09-04 |
rangers |
6 - 2 |
carpenter (1 - 7) |
26178 |
65 - 74 |
6 |
9999-09-05 |
rangers |
5 - 1 |
pavlik (2 - 4) |
27121 |
66 - 74 |
5 |
9999-09-06 |
rangers |
2 - 1 |
burkett (7 - 12) |
31232 |
67 - 74 |
2 |
9999-09-07 |
rangers |
4 - 0 |
oliver (11 - 11) |
30212 |
68 - 74 |
4 |
9999-09-08 |
angels |
12 - 10 |
james (4 - 5) |
25775 |
69 - 74 |
12 |
9999-09-09 |
angels |
2 - 0 |
hill (7 - 12) |
25674 |
70 - 74 |
2 |
9999-09-10 |
athletics |
3 - 2 |
plesac (1 - 4) |
4764 |
70 - 75 |
3 |
9999-09-11 |
athletics |
8 - 7 |
escobar (2 - 1) |
6135 |
70 - 76 |
8 |
9999-09-12 |
mariners |
7 - 3 |
clemens (21 - 6) |
37044 |
70 - 77 |
7 |
9999-09-13 |
mariners |
6 - 3 |
ayala (10 - 5) |
51631 |
71 - 77 |
6 |
9999-09-14 |
mariners |
3 - 2 |
risley (0 - 1) |
45477 |
71 - 78 |
3 |
9999-09-15 |
mariners |
7 - 3 |
williams (8 - 14) |
41684 |
71 - 79 |
7 |
9999-09-17 |
red sox |
4 - 3 |
quantrill (6 - 7) |
23648 |
71 - 80 |
4 |
9999-09-18 |
red sox |
3 - 2 |
escobar (3 - 2) |
27990 |
71 - 81 |
3 |
9999-09-19 |
yankees |
3 - 0 |
gooden (8 - 5) |
31195 |
72 - 81 |
3 |
9999-09-20 |
yankees |
4 - 3 (11) |
janzen (1 - 1) |
38332 |
72 - 82 |
4 |
9999-09-21 |
yankees |
5 - 4 (10) |
almanzar (0 - 1) |
40038 |
72 - 83 |
5 |
9999-09-22 |
yankees |
8 - 1 |
hentgen (15 - 10) |
23380 |
72 - 84 |
8 |
9999-09-23 |
orioles |
3 - 2 |
clemens (21 - 7) |
29276 |
72 - 85 |
3 |
9999-09-24 |
orioles |
9 - 3 |
daal (1 - 1) |
27443 |
72 - 86 |
9 |
9999-09-25 |
orioles |
4 - 3 |
mussina (15 - 8) |
28324 |
73 - 86 |
4 |
9999-09-26 |
red sox |
3 - 0 |
henry (7 - 3) |
34155 |
74 - 86 |
3 |
9999-09-27 |
red sox |
12 - 5 |
corsi (5 - 3) |
37401 |
75 - 86 |
12 |
9999-09-28 |
red sox |
3 - 2 |
gordon (6 - 10) |
40251 |
76 - 86 |
3 |
Step 4: Select rows where 'date' is '9999-09-01'.
date |
opponent |
score |
loss |
attendance |
record |
runs |
int_runs |
9999-09-06 |
rangers |
2 - 1 |
burkett (7 - 12) |
31232 |
67 - 74 |
2 |
2 |
Step 5: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
opponent |
score |
loss |
attendance |
record |
runs |
int_runs |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: FALSE