Step 1: Select rows where 'team' is 'cleveland'.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
| 2 |
9999-11-02 |
new jersey |
w 106 - 69 (ot) |
andrea bargnani (21) |
andrea bargnani , carlos delfino (6) |
josé calderón (8) |
izod center 14980 |
2 - 0 |
| 3 |
9999-11-04 |
boston |
l 95 - 98 (ot) |
t j ford (32) |
chris bosh (10) |
t j ford (5) |
air canada centre 19800 |
2 - 1 |
| 4 |
9999-11-06 |
milwaukee |
l 85 - 112 (ot) |
juan dixon (20) |
kris humphries (9) |
josé calderón (8) |
bradley center 13495 |
2 - 2 |
| 5 |
9999-11-07 |
orlando |
l 96 - 105 (ot) |
chris bosh (26) |
chris bosh (10) |
t j ford (8) |
air canada centre 17977 |
2 - 3 |
| 6 |
9999-11-09 |
philadelphia |
w 105 - 103 (ot) |
chris bosh (24) |
chris bosh (10) |
josé calderón (7) |
wachovia center 10886 |
3 - 3 |
| 7 |
9999-11-10 |
chicago |
w 101 - 71 (ot) |
carlos delfino (16) |
radoslav nesterović (8) |
t j ford (14) |
united center 22467 |
4 - 3 |
| 8 |
9999-11-14 |
utah |
l 88 - 92 (ot) |
anthony parker (19) |
kris humphries (14) |
t j ford (8) |
air canada centre 17337 |
4 - 4 |
| 9 |
9999-11-16 |
indiana |
w 110 - 101 (ot) |
chris bosh (22) |
jamario moon (7) |
josé calderón (10) |
air canada centre 19800 |
5 - 4 |
| 10 |
9999-11-18 |
golden state |
l 100 - 106 (ot) |
t j ford (29) |
chris bosh (11) |
t j ford (9) |
air canada centre 19800 |
5 - 5 |
| 11 |
9999-11-20 |
dallas |
l 99 - 105 (ot) |
chris bosh (31) |
chris bosh , jamario moon (12) |
josé calderón (6) |
american airlines center 20272 |
5 - 6 |
| 12 |
9999-11-21 |
memphis |
w 95 - 89 (ot) |
chris bosh (22) |
chris bosh (19) |
josé calderón (8) |
fedexforum 12217 |
6 - 6 |
| 13 |
9999-11-24 |
cleveland |
l 108 - 111 (ot) |
chris bosh (41) |
anthony parker (7) |
josé calderón (13) |
quicken loans arena 20018 |
6 - 7 |
| 14 |
9999-11-25 |
chicago |
w 93 - 78 (ot) |
josé calderón (19) |
chris bosh (13) |
josé calderón (14) |
air canada centre 19800 |
7 - 7 |
| 15 |
9999-11-28 |
memphis |
w 103 - 91 (ot) |
anthony parker (19) |
jamario moon , anthony parker (8) |
josé calderón (10) |
air canada centre 18906 |
8 - 7 |
Step 2: Select rows where 'date' is '9999-11-24'.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
| 13 |
9999-11-24 |
cleveland |
l 108 - 111 (ot) |
chris bosh (41) |
anthony parker (7) |
josé calderón (13) |
quicken loans arena 20018 |
6 - 7 |
Step 3: Select rows where 'score' is '108 - 111 (ot)'.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
| 13 |
9999-11-24 |
cleveland |
l 108 - 111 (ot) |
chris bosh (41) |
anthony parker (7) |
josé calderón (13) |
quicken loans arena 20018 |
6 - 7 |
Step 4: 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 |