Consider the following database table named Consider the following SQL query:…
PYQ GATE 2017
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 148 students.
Sign up free to check your answer
Sign up freeLoading lesson…

