Q. 61 Consider the following database table named top_scorer.
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 ____.
Note: This questions appeared as Numerical Answer Type.
(A) 6
(B) 7
(C) 8
(D) 9
Answer: (B)
Explanation:
