Which query will give you the list of all European countries where German is spoken?

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?

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’
)



Leave a Reply 6

Your email address will not be published. Required fields are marked *


jose

jose

I think is the A

G

G

I think it’s G