Statement: jonathan legear scored four more goals than matias suarez , the next highest ranked player in the belgian first dvision a league who played in the belgian cup
Input Table: 2008 - 09 r.s.c. anderlecht season
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 |
SQL Command:
SELECT
CASE
WHEN (SELECT league FROM table_sql WHERE player = 'jonathan legear') -
(SELECT league FROM table_sql WHERE player = 'matías suárez') > 4
THEN 'TRUE'
ELSE 'FALSE'
END;