Untitled
unknown
plain_text
a year ago
1.8 kB
7
Indexable
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;
Editor is loading...
Leave a Comment