Step 1: Extract the numerical values from the 'record' column to separate the number of wins and losses, then add columns 'wins' and 'losses' to the existing table.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
| 47 |
01-02-9999 |
portland |
l 79 - 98 (ot) |
raymond felton (23) |
gerald wallace (10) |
stephen jackson (4) |
rose garden 20106 |
24 - 23 |
| 48 |
9999-02-03 |
la lakers |
l 97 - 99 (ot) |
stephen jackson (30) |
nazr mohammed (17) |
boris diaw (5) |
staples center 18997 |
24 - 24 |
| 49 |
9999-02-06 |
new orleans |
l 99 - 104 (ot) |
stephen jackson (26) |
boris diaw (8) |
raymond felton (7) |
time warner cable arena 19164 |
24 - 25 |
| 50 |
9999-02-09 |
washington |
w 94 - 92 (ot) |
stephen jackson (22) |
nazr mohammed (10) |
raymond felton (5) |
time warner cable arena 12376 |
25 - 25 |
| 51 |
01-02-10 |
minnesota |
w 93 - 92 (ot) |
stephen jackson (33) |
nazr mohammed (20) |
dj augustin (7) |
target center 13352 |
26 - 25 |
| 52 |
01-02-16 |
new jersey |
l 94 - 103 (ot) |
gerald wallace (21) |
gerald wallace , boris diaw (10) |
stephen jackson (5) |
time warner cable arena 13712 |
26 - 26 |
| 53 |
9999-02-19 |
cleveland |
w 110 - 93 (ot) |
stephen jackson (29) |
tyrus thomas (12) |
boris diaw (9) |
time warner cable arena 19568 |
27 - 26 |
| 54 |
9999-02-20 |
milwaukee |
l 88 - 93 (ot) |
stephen jackson (35) |
tyrus thomas (11) |
stephen jackson (5) |
bradley center 17174 |
27 - 27 |
| 55 |
9999-02-22 |
la clippers |
l 94 - 98 (ot) |
gerald wallace (32) |
gerald wallace (12) |
boris diaw , raymond felton (9) |
staples center 15892 |
27 - 28 |
| 56 |
9999-02-24 |
utah |
l 93 - 102 (ot) |
gerald wallace (27) |
gerald wallace (8) |
raymond felton (5) |
energysolutions arena 19911 |
27 - 29 |
Step 2: Select rows where the value in the 'wins' column is greater than the value in the 'losses' column.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
wins |
losses |
| 47 |
01-02-9999 |
portland |
l 79 - 98 (ot) |
raymond felton (23) |
gerald wallace (10) |
stephen jackson (4) |
rose garden 20106 |
24 - 23 |
24 |
23 |
| 48 |
9999-02-03 |
la lakers |
l 97 - 99 (ot) |
stephen jackson (30) |
nazr mohammed (17) |
boris diaw (5) |
staples center 18997 |
24 - 24 |
24 |
24 |
| 49 |
9999-02-06 |
new orleans |
l 99 - 104 (ot) |
stephen jackson (26) |
boris diaw (8) |
raymond felton (7) |
time warner cable arena 19164 |
24 - 25 |
24 |
25 |
| 50 |
9999-02-09 |
washington |
w 94 - 92 (ot) |
stephen jackson (22) |
nazr mohammed (10) |
raymond felton (5) |
time warner cable arena 12376 |
25 - 25 |
25 |
25 |
| 51 |
01-02-10 |
minnesota |
w 93 - 92 (ot) |
stephen jackson (33) |
nazr mohammed (20) |
dj augustin (7) |
target center 13352 |
26 - 25 |
26 |
25 |
| 52 |
01-02-16 |
new jersey |
l 94 - 103 (ot) |
gerald wallace (21) |
gerald wallace , boris diaw (10) |
stephen jackson (5) |
time warner cable arena 13712 |
26 - 26 |
26 |
26 |
| 53 |
9999-02-19 |
cleveland |
w 110 - 93 (ot) |
stephen jackson (29) |
tyrus thomas (12) |
boris diaw (9) |
time warner cable arena 19568 |
27 - 26 |
27 |
26 |
| 54 |
9999-02-20 |
milwaukee |
l 88 - 93 (ot) |
stephen jackson (35) |
tyrus thomas (11) |
stephen jackson (5) |
bradley center 17174 |
27 - 27 |
27 |
27 |
| 55 |
9999-02-22 |
la clippers |
l 94 - 98 (ot) |
gerald wallace (32) |
gerald wallace (12) |
boris diaw , raymond felton (9) |
staples center 15892 |
27 - 28 |
27 |
28 |
| 56 |
9999-02-24 |
utah |
l 93 - 102 (ot) |
gerald wallace (27) |
gerald wallace (8) |
raymond felton (5) |
energysolutions arena 19911 |
27 - 29 |
27 |
29 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is greater than 0, otherwise return FALSE.
| game |
date |
team |
score |
high_points |
high_rebounds |
high_assists |
location_attendance |
record |
wins |
losses |
| 47 |
01-02-9999 |
portland |
l 79 - 98 (ot) |
raymond felton (23) |
gerald wallace (10) |
stephen jackson (4) |
rose garden 20106 |
24 - 23 |
24 |
23 |
| 51 |
01-02-10 |
minnesota |
w 93 - 92 (ot) |
stephen jackson (33) |
nazr mohammed (20) |
dj augustin (7) |
target center 13352 |
26 - 25 |
26 |
25 |
| 53 |
9999-02-19 |
cleveland |
w 110 - 93 (ot) |
stephen jackson (29) |
tyrus thomas (12) |
boris diaw (9) |
time warner cable arena 19568 |
27 - 26 |
27 |
26 |