Consider the following query:
SELECT Name
FROM Country
WHERE Continent = ‘Europe’
AND Code = ANY (SELECT Continent, CountryCode
FROM CountryLanguage
WHERE Language = ‘Dutch’)
What would be the result of executing this query?
A.
list of all countries in Europe where Dutch is spoken.
B.
A random country in Europe where Dutch is spoken.
C.
An error telling you that there is a syntax error near ANY.
D.
An error telling you that the operand can only contain one column.
Explanation:
It’s tying to compare 1 value (Code) with 2 returned values (Continent and CountryCode) – ERROR.