Step 1: Select rows where the 'b_score' is more than 9.225.
| 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 |
Step 2: Select rows where the 'total' is less than 15.975.
| position |
gymnast |
a_score |
b_score |
total |
Step 3: Select rows where the 'a_score' is 6.800.
| position |
gymnast |
a_score |
b_score |
total |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
| position |
gymnast |
a_score |
b_score |
total |