Exercise : Languages in France

List all of the languages that are spoken in France, as well as the expected number of speakers for that language (population * percentage). Do this as a single query. Do not hard code the country code into your query. (JOIN) Expected results:

+--------------+-----------+--------------+-------------------+
| language     | official  | percentage   | estimated_speakers|
+--------------+-----------+--------------+-------------------+
| Arabic       | F         | 2.5          | 5543525429.6      |
| French       | T         | 93.6         | 148064250.0       |
| Italian      | F         | 0.4          | 71070842.8        |
| Portugese    | F         | 1.2          | 23690280.4        | 
| Spanish      | F         | 0.4          | 23690280.4        |
| Turkish      | F         | 0.4          | 23690280.4        |
+--------------+-----------+--------------+-------------------+

Exercise Solution

SELECT language, official, percentage, 
       percentage * population as estimated_speakers
FROM countries
JOIN languages ON country_code = code
WHERE countries.name = "France"