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 taWHERE 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 ______.

Test Index

GATE Computer Science (CS) 2017 Shift 2 Solved Paper

Question : 56

Total: 65

Go to Question:

Prev Question

Next Question