Statement: 6.800 is the a score when the b score is more than 9.225 , and the total is less than 15.975
Input Table: gymnastics at the 2008 summer olympics - men 's rings
position | gymnast | a_score | b_score | total |
1 | chen yibing ( chn ) | 7.3 | 9.225 | 16.525 |
2 | yordan yovchev ( bul ) | 7.3 | 8.975 | 16.275 |
3 | oleksandr vorobiov ( ukr ) | 7.2 | 9.05 | 16.25 |
4 | yang wei ( chn ) | 7.3 | 8.925 | 16.225 |
5 | matteo morandi ( ita ) | 7.1 | 8.925 | 16.025 |
6 | andrea coppolino ( ita ) | 6.8 | 9.175 | 15.975 |
7 | danny pinheiro rodrigues ( fra ) | 7.2 | 8.6 | 15.8 |
8 | robert stanescu ( rou ) | 7.0 | 8.75 | 15.75 |
SQL Command:
SELECT
CASE
WHEN (SELECT a_score FROM table_sql WHERE b_score > 9.225 AND total < 15.975) = 6.800
THEN 'TRUE'
ELSE 'FALSE'
END;