1. Inner Join

SELECT C.Code AS "Country Code", C.Name AS "Country", C.Continent, CL.Language

FROM (Country C

INNER JOIN CountryLanguage CL ON CL.CountryCode = C.Code)

ORDER BY Country ASC