1
SELECT Name FROM country WHERE name like‘K%’;
2
SELECT Name, IndepYear FROM country WHERE IndepYear BETWEEN 1900 and 1899;
3
SELECT Name, Region FROM country WHERE Region LIKE ‘Middle East’;
4
SELECT Name, IndepYear FROM country WHERE IndepYear BETWEEN 1900 and 1899 AND Continent LIKE ‘Europe’
5
SELECT Name
From country
WHERE Name LIKE ‘%pa%’
6
SELECT Name
FROM country
WHERE Name LIKE ‘A%’ OR Name LIKE ‘E%’ OR Name LIKE ‘I%’ OR Name LIKE ‘O%’ OR Name LIKE ‘U%’ OR Name LIKE ‘Y%’
7
SELECT Name
FROM country
WHERE LEFT(Name,1)= RIGHT(Name,1)
8
SELECT Name, GovernmentForm
FROM country
WHERE GovernmentForm LIKE ‘%monarchy%’
10
SELECT Name, IndepYear FROM country
ORDER By IndepYear
LIMIT 1
9
SELECT Name, Population
FROM country
WHERE Population <1000000;
11
SELECT Name, IndepYear FROM country WHERE IndepYear=0;
15
SELECT Name,Population,Continent
FROM country
Where Continent LIKE ‘Europe’
ORDER BY Population DESC limit 10
16
SELECT SUM(Population) as kokku, sum(SurfaceArea) as pindala
from country
Where Continent like’Europe’;
17
SELECTcount(Name)as kogus from country WHERE Continent notlike‘Antarctica%’;
18
SELECT COUNT(Name) as kogus,
SUM(Population) as kokku
FROM country
WHERE HeadOfState LIKE ‘Elisabeth%’
19
SELECT count(Name) AS Kogus, MIN(Population) AS minPpulation, MAX(Population) AS maxPopulation FROM country
Where Region LIKE ‘Polynesia’
