What-what for skaters with a Rank in FS larger than 2 , and a Final Rank larger than 5 is that average SP a rank ?
Final Rank Skater Rank in SP Rank in FS Total Score
Figure skating at the 1998 Winter Olympics
1158735
real text real real text
2-1158735-9
Program details
Program details
1 Tara Lipinski 2 1 2.0 ( 2 * 0.5 + 1 = 2.0 )
2 Michelle Kwan 1 2 2.5 ( 1 * 0.5 + 2 = 2.5 )
3 Chen Lu 4 3 5.0 ( 4 * 0.5 + 3 = 5.0 )
4 Maria Butyrskaya 3 4 5.5 ( 3 * 0.5 + 4 = 5.5 )
5 Irina Slutskaya 5 5 7.5 ( 5 * 0.5 + 5 = 7.5 )
SELECT AVG Rank in SP FROM table WHERE Rank in FS > 2 AND Final Rank > 5
2 5