Step 1: Select rows where 'date' is '9999-11-27'.
game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
1 |
9999-11-14 |
delaware |
w 76 - 56 |
ryan brooks - 23 |
lavoy allen - 15 |
juan fernandez - 5 |
bob carpenter center , newark , de (3080) |
1 - 0 |
2 |
9999-11-17 |
georgetown (19) |
l 46 - 45 |
allen - 12 |
allen - 14 |
luiz guzman - 6 |
verizon center , washington , dc (8712) |
1 - 1 |
3 |
9999-11-21 |
siena |
w 73 - 69 |
fernandez - 20 |
allen - 7 |
allen - 5 |
liacouras center , philadelphia , pa (6759) |
2 - 1 |
4 |
9999-11-24 |
ball state |
w 66 - 46 |
brooks - 17 |
allen - 9 |
allen / brooks - 7 |
liacouras center , philadelphia , pa (3597) |
3 - 1 |
5 |
9999-11-27 |
virginia tech |
w 61 - 50 |
allen - 18 |
allen - 10 |
fernandez - 6 |
palestra , philadelphia , pa (3750) |
4 - 1 |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
5 |
9999-11-27 |
virginia tech |
w 61 - 50 |
allen - 18 |
allen - 10 |
fernandez - 6 |
palestra , philadelphia , pa (3750) |
4 - 1 |
Prediction: TRUE
Ground-truth: TRUE