Step 1: Select rows where 'date' is '9999-05-20'.
date |
winning_team |
score |
winning_pitcher |
losing_pitcher |
attendance |
location |
9999-05-20 |
texas |
7 - 3 |
kenny rogers |
brandon backe |
38109 |
arlington |
9999-05-21 |
texas |
18 - 3 |
chris young |
ezequiel astacio |
35781 |
arlington |
9999-05-22 |
texas |
2 - 0 |
chan ho park |
roy oswalt |
40583 |
arlington |
9999-06-24 |
houston |
5 - 2 |
roy oswalt |
ricardo rodrÃguez |
36199 |
houston |
9999-06-25 |
texas |
6 - 5 |
chris young |
brandon backe |
41868 |
houston |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
winning_team |
score |
winning_pitcher |
losing_pitcher |
attendance |
location |
9999-05-20 |
texas |
7 - 3 |
kenny rogers |
brandon backe |
38109 |
arlington |
Prediction: TRUE