1.

Consider the following database table named top_scorer.
Player Country Goals
Klose Germany 16
Ronaldo Brazil 15
G Muller Gemany 14
Fontaine France 13
Pele Brazil 12
Klinsmann Germany 11
Kocsis Hungary 11
Batistuta Argentina 10
Cubillas Peru 10
Lato Poland 10
Lineker England 10
T Miller Germany 10
Rahn Germany 10

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 ________.

A. 21
B. 7
C. 0
D. 3
Answer» C. 0


Discussion

No Comment Found

Related MCQs