Step 1: Select rows where 'set_3' is '25 - 13'.
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 'total' is '75 - 34'.
date |
score |
set_1 |
set_2 |
set_3 |
total |
9999-07-13 |
3 - 0 |
25 - 23 |
25 - 10 |
25 - 13 |
75 - 46 |
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