Consider the following database table named Consider the following SQL query:…

GATE · 2017 · CS · Set 2 · Computer Science & IT

Consider the following database table named

Consider the following SQL query:

SELECT ta.player FROM top_scorer AS ta

WHERE ta.goals >ALL (SELECT tb.goals

FROM top_scorer AS tb

WHERE tb.country = 'Spain')

AND ta.goals > ANY (SELECT tc.goals

FROM top_scorer AS tc

WHERE tc.country='Germany')

The number of tuples returned by the above SQL query is ______

Attempted by 128 students.