Consider the following database table named top_scorer. Top_scorer player country Goals Klose Germany 16 Ronaldo Brazil 15 G miller Germany 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 ______.

GATE Computer Science (CS) 2017 Shift 2 Solved Paper

Question : 56 of 65

Marks: +1, -0

Consider the following database table named top_scorer.
Top_scorer

player	country	Goals
Klose	Germany	16
Ronaldo	Brazil	15
G miller	Germany	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 ______.

Your Answer:

Validate

Go to Question:

Prev Question

Next Question