SELECT Code, CountryName, COntinent, IndepYear
FROM tCountry
WHERE --Continent IN ('Asia','Europe')
-- Continent LIKE 'Asia' OR Continent LIKE 'Europe'
SELECT Code, CountryName, Continent
FROM tCOuntry
WHERE Continent LIKE '%Ameri_a'
SELECT DISTINCT Continent -- mitte korduvate väärtustega kontinentide loetelu
FROM tCountry
-- Euroopa 10 kõige nooremat riigi
SELECT TOP 10 WITH TIES Code, CountryName, COntinent, IndepYear
FROM tCountry
WHERE IndepYear IS NOT NULL AND Continent LIKE 'Europe'
ORDER BY IndepYear DESC