Step 1: Select the maximum score from the 'points' column and subtract the minimum score from the 'points' column to get the point difference.
| rank |
name |
nation |
sp___fs |
points |
places |
| 1 |
linda fratianne |
united states |
1 |
186.92 |
11 |
| 2 |
anett pötzsch |
east germany |
3 |
184.36 |
18 |
| 3 |
emi watanabe |
japan |
4 |
180.52 |
31 |
| 4 |
dagmar lurz |
west germany |
6 |
179.96 |
33 |
| 5 |
denise biellmann |
switzerland |
2 |
177.28 |
49 |
| 6 |
lisa - marie allen |
united states |
5 |
176.68 |
54 |
| 7 |
claudia kristofics - binder |
austria |
7 |
175.44 |
63 |
| 8 |
susanna driano |
italy |
9 |
173.46 |
70 |
| 9 |
carola weißenberg |
east germany |
11 |
170.54 |
88 |
| 10 |
kristiina wegelius |
finland |
15 |
169.26 |
98 |
| 11 |
carrie rugh |
united states |
10 |
169.34 |
97 |
| 12 |
sanda dubravčić |
yugoslavia |
8 |
166.96 |
115 |
| 13 |
natalia strelkova |
soviet union |
16 |
164.94 |
134 |
| 14 |
deborah cottrill |
united kingdom |
20 |
164.8 |
136 |
| 15 |
karin riediger |
west germany |
17 |
164.5 |
142 |
| 16 |
renata baierova |
czechoslovakia |
13 |
164.0 |
144 |
| 17 |
petra ernert |
west germany |
14 |
163.24 |
149 |
| 18 |
kira ivanova |
soviet union |
12 |
164.02 |
147 |
| 19 |
janet morrissey |
canada |
18 |
162.04 |
162 |
| 20 |
reiko kobayashi |
japan |
21 |
161.3 |
170 |
| 21 |
jeanne chapman |
norway |
19 |
161.8 |
166 |
| 22 |
anita siegfried |
switzerland |
26 |
150.34 |
207 |
| 23 |
astrid jansen in de wal |
netherlands |
25 |
149.18 |
216 |
| 24 |
franca bianconi |
italy |
22 |
149.04 |
218 |
| 25 |
bodil olsson |
sweden |
23 |
147.02 |
225 |
| 26 |
corine wyrsch |
switzerland |
27 |
146.76 |
233 |
| 27 |
kim myo sil |
north korea |
24 |
145.48 |
237 |
| 28 |
belinda coulthard |
australia |
28 |
145.92 |
238 |
| 29 |
katie symmonds |
new zealand |
29 |
134.58 |
261 |
| 30 |
shin hae sook |
south korea |
30 |
120.44 |
270 |
| 31 |
gloria mas |
spain |
31 |
112.28 |
279 |
Step 2: Use a `CASE` statement to return TRUE if the point difference is equal to 74.64, otherwise return FALSE.
| point_difference |
| 74.63999999999999 |
Final output table:
| verification_result |
| FALSE |
Prediction: FALSE
Ground-truth: TRUE