Find your solution to the section called “Assignment 9.0”. For the sake of a good overview I repeat the table descriptions:
describe country; +----------------+------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------------+------+-----+---------+-------+ | Code | char(3) | NO | PRI | | | | Name | char(52) | NO | | | | ... | Population | int(11) | NO | | 0 | | ... +----------------+------------------------+------+-----+---------+-------+
239 countries in the table.
describe countrylanguage;
+-------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| countrycode | char(3) | NO | PRI | | |
| language | char(30) | NO | PRI | | |
| isofficial | enum('T','F') | NO | | F | |
| percentage | float(4,1) | NO | | 0.0 | |
+-------------+---------------+------+-----+---------+-------+
984 languages in the world.
Now you must tally how many people speak each of those languages.
You already programmed the solution in the section called “Assignment 9.0”. Now you must code it in SQL and PHP, so that we can see a solution based on world data displayed on the screen. You may refer to the section called “Assignment 6.3” for the bulk of the menial work in the solution. That way you may here concentrate on translating you paperbased solution to code.