Step 1: Order the table by 'total' in descending order.
| player |
league |
title_playoff |
super_cup |
total |
| mbark boussoufa |
11 |
0 |
0 |
11 |
| tom de sutter |
9 |
0 |
0 |
9 |
| guillaume gillet |
8 |
0 |
0 |
9 |
| marcin wasilewski |
8 |
0 |
0 |
8 |
| jonathan legear |
5 |
1 |
0 |
7 |
| nicolás frutos |
6 |
0 |
0 |
6 |
| thomas chatelle |
4 |
0 |
0 |
4 |
| roland juhász |
4 |
0 |
0 |
4 |
| stanislav vlček |
4 |
0 |
0 |
4 |
| lucas biglia |
2 |
0 |
0 |
3 |
| dmitri bulykin |
3 |
0 |
0 |
3 |
| jan polák |
2 |
0 |
0 |
3 |
| matías suárez |
1 |
0 |
1 |
3 |
| jelle van damme |
3 |
0 |
0 |
3 |
| oleksandr iakovenko |
2 |
0 |
0 |
2 |
| hernán losada |
1 |
0 |
0 |
2 |
| víctor bernárdez |
1 |
0 |
0 |
1 |
| bart goor |
1 |
0 |
0 |
1 |
| nemanja rnić |
0 |
0 |
0 |
1 |
Step 2: Select row number 1.
| player |
league |
title_playoff |
super_cup |
total |
| mbark boussoufa |
11 |
0 |
0 |
11 |
| tom de sutter |
9 |
0 |
0 |
9 |
| guillaume gillet |
8 |
0 |
0 |
9 |
| marcin wasilewski |
8 |
0 |
0 |
8 |
| jonathan legear |
5 |
1 |
0 |
7 |
| nicolás frutos |
6 |
0 |
0 |
6 |
| thomas chatelle |
4 |
0 |
0 |
4 |
| roland juhász |
4 |
0 |
0 |
4 |
| stanislav vlček |
4 |
0 |
0 |
4 |
| lucas biglia |
2 |
0 |
0 |
3 |
| dmitri bulykin |
3 |
0 |
0 |
3 |
| jan polák |
2 |
0 |
0 |
3 |
| matías suárez |
1 |
0 |
1 |
3 |
| jelle van damme |
3 |
0 |
0 |
3 |
| oleksandr iakovenko |
2 |
0 |
0 |
2 |
| hernán losada |
1 |
0 |
0 |
2 |
| víctor bernárdez |
1 |
0 |
0 |
1 |
| bart goor |
1 |
0 |
0 |
1 |
| nemanja rnić |
0 |
0 |
0 |
1 |
Step 3: Select rows where 'player' is 'jonathan legear'.
| player |
league |
title_playoff |
super_cup |
total |
| mbark boussoufa |
11 |
0 |
0 |
11 |
Step 4: Extract the numerical value of goals scored by Jonathan Legear from the 'total' column then add column 'jonathan_goals' to existing table.
| player |
league |
title_playoff |
super_cup |
total |
Step 5: Select rows where 'player' is 'matías suárez'.
| player |
league |
title_playoff |
super_cup |
total |
jonathan_goals |
Step 6: Extract the numerical value of goals scored by Matías Suárez from the 'total' column then add column 'matias_goals' to existing table.
| player |
league |
title_playoff |
super_cup |
total |
jonathan_goals |
Step 7: Subtract 'matias_goals' from 'jonathan_goals' and add column 'goal_difference' to existing table.
| player |
league |
title_playoff |
super_cup |
total |
jonathan_goals |
matias_goals |
Step 8: Select rows where 'goal_difference' is equal to 4.
| player |
league |
title_playoff |
super_cup |
total |
jonathan_goals |
matias_goals |
goal_difference |
Step 9: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| player |
league |
title_playoff |
super_cup |
total |
jonathan_goals |
matias_goals |
goal_difference |
| verification_result |
| FALSE |