Consider the structures of the country and countrylanguage tables.
mysql >DESCRIBE country;
mysql> DESCRIBE countrylanguage;
Which query will give you the list of all European countries where German is spoken?
A.
SELECT Code AS c, Name
FROM Country
WHERE Continent = ‘Europe’
AND EXISTS (
SELECT *
FROM CountryLanguage
WHERE CountryCode = Code
And Language= ‘German’
)
B.
SELECT Code AS c, Name
FROM Country
WHERE Continent = ‘Europe’
AND Name IN (
SELECT *
FROM CountryLanguage
WHERE CountryCode = Code
AND Language =’German’
)
C.
SELECT Code AS c, Name
FROM Country
WHERE Continent = ‘ Europe’
AND EXIST ANY (
SELECT Language, CountryCode
FROM CountryLanguage
WHERE CountryCode =Code
AND Language = ‘German’
)
D.
SELECT Code AS c, Name
FROM Country
WHERE Continent = ‘Europe’
AND (
SELECT *
FROM CountryLanguage
WHERE CountryCode =Code
AND Language =’German’
)
I think is the A
It’s A
A
A
A
I think it’s G