Step 1: Select rows where 'set_2' is '16 - 25'.
| date |
score |
set_1 |
set_2 |
set_3 |
total |
| 9999-07-13 |
0 - 3 |
9 - 25 |
17 - 25 |
12 - 25 |
38 - 75 |
| 9999-07-13 |
3 - 0 |
25 - 23 |
25 - 10 |
25 - 13 |
75 - 46 |
| 9999-07-14 |
3 - 0 |
25 - 13 |
25 - 10 |
25 - 11 |
75 - 34 |
| 9999-07-14 |
1 - 3 |
25 - 22 |
16 - 25 |
15 - 25 |
70 - 97 |
| 9999-07-15 |
0 - 3 |
16 - 25 |
19 - 25 |
18 - 25 |
53 - 75 |
| 9999-07-15 |
3 - 0 |
25 - 23 |
25 - 16 |
25 - 14 |
75 - 53 |
Step 2: Select rows where 'date' is '9999-07-15'.
| date |
score |
set_1 |
set_2 |
set_3 |
total |
| 9999-07-14 |
1 - 3 |
25 - 22 |
16 - 25 |
15 - 25 |
70 - 97 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| date |
score |
set_1 |
set_2 |
set_3 |
total |
Final output table:
| verification_result |
| FALSE |
Prediction: FALSE
Ground-truth: FALSE