Untitled

1). SELECT * FROM country;

2). SELECT * FROM city
WHERE District = 'Dhaka';

3). SELECT Name FROM city
WHERE CountryCode IN ('ARG', 'IDN');

4). SELECT Name FROM city
WHERE CountryCode IN ('ARG', 'IDN', 'THA', 'ESP');

5). SELECT DISTINCT countryCode FROM countrylanguage
WHERE IsOfficial = true AND Language = 'English';

6).SELECT Name, SurfaceArea
FROM country
ORDER BY SurfaceArea ASC
LIMIT 10;

7). SELECT cl.countryCode, c.Name AS CountryName, cl.Percentage
FROM countrylanguage cl
JOIN country c ON cl.countryCode = c.Code
WHERE cl.Language = 'English' AND cl.Percentage > 50;

8). SELECT DISTINCT Language
FROM countrylanguage;

9). SELECT DISTINCT Region
FROM country
WHERE Continent = 'Europe';

10). SELECT Name AS CityName, Population
FROM city
ORDER BY Population DESC
LIMIT 25;

11). SELECT Name AS CountryName
FROM country
WHERE Capital IS NULL OR Capital = '';

12). SELECT Name AS CountryName
FROM country
WHERE Continent = 'Asia'
ORDER BY Name
LIMIT 10 OFFSET 10;

13). SELECT Name AS CountryName
FROM country
WHERE Name LIKE '%land%';

14). SELECT Name AS CountryName
FROM country
WHERE Name LIKE '%land%' AND Name NOT LIKE '%island%';

15). SELECT Name AS CountryName
FROM country
WHERE LENGTH(Name) > 8;

16). SELECT Name AS CountryName
FROM country
WHERE Name LIKE 'G%a';

17). SELECT Name AS CountryName
FROM country
WHERE LENGTH(Name) = 6;

18). SELECT Name AS CountryName
FROM country
WHERE Name <> LocalName;

19). SELECT c.Name AS CountryName, cl.Language, cl.IsOfficial
FROM country c
JOIN countrylanguage cl ON c.Code = cl.countryCode
WHERE c.Continent <> 'Europe' AND cl.Language = 'English' AND cl.IsOfficial = true;

20).SELECT Name AS CountryName, Population
FROM country
ORDER BY Population DESC
LIMIT 10;