MySQL Workbench was used to access the world_x database and retrieve data from it.
List of codes for countries where English is spoken by more than 30% of the population.
Query
SELECT `country`.`Code`
FROM `world_x`.`country`
INNER JOIN `countrylanguage`
ON `country`.`Code` = `countrylanguage`.`CountryCode`
WHERE `countrylanguage`.`Language` = 'English' AND `countrylanguage`.`Percentage` > 30.0
ORDER BY `country`.`Code` ASC;
Result Dataset
Figure 1. A screen shot of the query and the results.
List of codes for countries where English is spoken by less than 30% of the population.
Query
SELECT `country`.`Code`
FROM `world_x`.`country`
INNER JOIN `countrylanguage`
ON `country`.`Code` = `countrylanguage`.`CountryCode`
WHERE `countrylanguage`.`Language` = 'English' AND `countrylanguage`.`Percentage` < 30.0
ORDER BY `country`.`Code` ASC
LIMIT 20;
Result Dataset
Figure 2. A screen shot of the query and the results.
References
Forta B. (2012). Sams Teach Yourself SQL in 10 Minutes. Indianapolis, IN: Sams Publishing
Sheldon R. & Moeg G. (2005). Beginning MySQL. Indianapolis, IN: Wiley & Sons
Delegate your assignment to our experts and they will do the rest.
