Step 1: Select rows where 'location' is 'tokyo' and 'country' is 'japan'.
res |
record |
opponent |
method |
event |
round |
time |
location |
loss |
19 - 9 - 4 |
naoyuki kotani |
submission (armbar) |
9999-01-01 |
1 |
9999-01-01 |
9999-01-01 |
loss |
19 - 8 - 4 |
kota okazawa |
ko (punch) |
9999-01-01 |
1 |
9999-01-01 |
9999-01-01 |
win |
19 - 7 - 4 |
katsuhiko nagata |
decision (unanimous) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
loss |
18 - 7 - 4 |
maximo blanco |
tko (strikes) |
9999-01-01 |
2 |
9999-01-01 |
9999-01-01 |
draw |
18 - 6 - 4 |
mizuto hirota |
draw |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
17 - 6 - 3 |
koji oishi |
decision (unanimous) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
18 - 6 - 3 |
daisuke hanazawa |
decision (unanimous) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
loss |
16 - 6 - 3 |
nick diaz |
tko (corner stoppage) |
9999-01-01 |
1 |
9999-01-01 |
9999-01-01 |
draw |
16 - 5 - 3 |
djamal kurbanov |
draw |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
16 - 5 - 2 |
satoru kitaoka |
decision (split) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
draw |
15 - 5 - 2 |
shigetoshi iwase |
draw |
2007-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
15 - 5 - 1 |
fabricio nascimento |
tko (punches) |
2007-01-01 |
2 |
9999-01-01 |
9999-01-01 |
win |
14 - 5 - 1 |
koji oishi |
ko (punches) |
9999-01-01 |
2 |
9999-01-01 |
9999-01-01 |
x loss |
13 - 5 - 1 |
yoshiyuki yoshida |
ko (punch) |
9999-01-01 |
1 |
9999-01-01 |
9999-01-01 |
win |
13 - 4 - 1 |
takefume hanai |
tko (punches) |
9999-01-01 |
2 |
9999-01-01 |
9999-01-01 |
x loss |
12 - 4 - 1 |
daizo ishige |
decision (unanimous) |
9999-01-06 |
3 |
9999-01-01 |
9999-01-01 |
win |
12 - 3 - 1 |
kim haeng ki |
tko (punches) |
9999-03-01 |
3 |
9999-01-01 |
9999-01-01 |
draw |
11 - 3 - 1 |
satoru kitaoka |
draw |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
11 - 3 |
daisuke hanazawa |
decision (majority) |
9999-01-04 |
3 |
9999-01-01 |
9999-01-01 |
x loss |
10 - 3 |
akira kikuchi |
tko (punches) |
9999-01-02 |
1 |
9999-01-01 |
9999-01-01 |
win |
10 - 2 |
kenji arai |
ko (punch) |
9999-01-01 |
2 |
9999-01-01 |
9999-01-01 |
win |
9 - 2 |
heath sims |
tko (punches) |
9999-01-01 |
1 |
9999-01-01 |
9999-01-01 |
win |
8 - 2 |
kyle noke |
decision (split) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
7 - 2 |
satoru kitaoka |
decision (unanimous) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
6 - 2 |
takuya wada |
decision (unanimous) |
9999-01-01 |
3 |
9999-01-01 |
9999-01-01 |
win |
5 - 2 |
hikaru sato |
tko (punches) |
9999-01-01 |
1 |
9999-01-01 |
9999-01-01 |
win |
4 - 2 |
ichiro kanai |
decision (majority) |
9999-01-01 |
2 |
9999-01-01 |
9999-01-01 |
x loss |
3 - 2 |
eiji ishikawa |
decision (majority) |
9999-01-01 |
2 |
9999-01-01 |
9999-01-01 |
win |
3 - 1 |
taro minato |
decision (unanimous) |
9999-01-12 |
2 |
9999-01-01 |
9999-01-01 |
win |
2 - 1 |
ichiro kanai |
decision (unanimous) |
9999-01-07 |
2 |
9999-01-01 |
9999-01-01 |
win |
1 - 1 |
motohiro tachihara |
decision (unanimous) |
9999-01-05 |
2 |
9999-01-01 |
9999-01-01 |
x loss |
0 - 1 |
yoshinori oniki |
tko (strikes) |
9999-01-04 |
1 |
9999-01-09 |
9999-01-01 |
Step 2: Select rows where 'opponent' is 'hikaru sato'.
res |
record |
opponent |
method |
event |
round |
time |
location |
Step 3: Select rows where 'round' is less than 2.
res |
record |
opponent |
method |
event |
round |
time |
location |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
res |
record |
opponent |
method |
event |
round |
time |
location |
Final output table:
verification_result |
FALSE |
Prediction: FALSE