Step 1: Select rows where 'location_attendance' is 'pepsi center'.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
| 3 |
9999-11-01 |
grizzlies |
w 133 - 123 (ot) |
carmelo anthony (42) |
nenê (9) |
chauncey billups (12) |
pepsi center 15823 |
3 - 0 |
| 4 |
9999-11-03 |
pacers |
w 111 - 93 (ot) |
carmelo anthony (25) |
nenê (13) |
anthony carter (5) |
conseco fieldhouse 10627 |
4 - 0 |
| 5 |
9999-11-04 |
nets |
w 122 - 94 (ot) |
ty lawson (23) |
kenyon martin (10) |
chauncey billups (5) |
izod center 15319 |
5 - 0 |
| 7 |
9999-11-07 |
hawks |
l 100 - 125 (ot) |
carmelo anthony (30) |
chris andersen (11) |
chauncey billups (7) |
philips arena 17801 |
5 - 2 |
| 8 |
9999-11-10 |
bulls |
w 90 - 89 (ot) |
carmelo anthony (20) |
nenê (12) |
chauncey billups (6) |
united center 21409 |
6 - 2 |
| 9 |
9999-11-11 |
bucks |
l 102 - 108 (ot) |
carmelo anthony (32) |
carmelo anthony (10) |
chauncey billups , ty lawson (5) |
bradley center 12987 |
6 - 3 |
| 10 |
9999-11-13 |
lakers |
w 105 - 79 (ot) |
carmelo anthony (25) |
chris andersen (11) |
chauncey billups (8) |
pepsi center 19141 |
7 - 3 |
| 11 |
9999-11-17 |
raptors |
w 130 - 112 (ot) |
carmelo anthony (32) |
nenê (10) |
chauncey billups (10) |
pepsi center 16446 |
8 - 3 |
| 12 |
9999-11-20 |
clippers |
l 99 - 106 (ot) |
carmelo anthony (37) |
nenê (12) |
chauncey billups (7) |
staples center 18155 |
8 - 4 |
| 13 |
9999-11-21 |
bulls |
w 112 - 93 (ot) |
carmelo anthony (30) |
carmelo anthony , kenyon martin (11) |
carmelo anthony (7) |
pepsi center 19359 |
9 - 4 |
| 14 |
9999-11-24 |
nets |
w 101 - 87 (ot) |
carmelo anthony (27) |
nenê (9) |
chauncey billups (7) |
pepsi center 16307 |
10 - 4 |
| 15 |
9999-11-25 |
timberwolves |
w 124 - 111 (ot) |
carmelo anthony (22) |
nenê (8) |
nenê , ty lawson (6) |
target center 13101 |
11 - 4 |
| 16 |
9999-11-27 |
knicks |
w 128 - 125 (ot) |
carmelo anthony (50) |
nenê , kenyon martin (11) |
chauncey billups (8) |
pepsi center 19155 |
12 - 4 |
Step 2: Select rows where 'attendance' is less than or equal to 15000.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
| 3 |
9999-11-01 |
grizzlies |
w 133 - 123 (ot) |
carmelo anthony (42) |
nenê (9) |
chauncey billups (12) |
pepsi center 15823 |
3 - 0 |
| 10 |
9999-11-13 |
lakers |
w 105 - 79 (ot) |
carmelo anthony (25) |
chris andersen (11) |
chauncey billups (8) |
pepsi center 19141 |
7 - 3 |
| 11 |
9999-11-17 |
raptors |
w 130 - 112 (ot) |
carmelo anthony (32) |
nenê (10) |
chauncey billups (10) |
pepsi center 16446 |
8 - 3 |
| 13 |
9999-11-21 |
bulls |
w 112 - 93 (ot) |
carmelo anthony (30) |
carmelo anthony , kenyon martin (11) |
carmelo anthony (7) |
pepsi center 19359 |
9 - 4 |
| 14 |
9999-11-24 |
nets |
w 101 - 87 (ot) |
carmelo anthony (27) |
nenê (9) |
chauncey billups (7) |
pepsi center 16307 |
10 - 4 |
| 16 |
9999-11-27 |
knicks |
w 128 - 125 (ot) |
carmelo anthony (50) |
nenê , kenyon martin (11) |
chauncey billups (8) |
pepsi center 19155 |
12 - 4 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
Prediction: TRUE