CMIS 320

CountryLanguage queries.
CountryLanguage has 984 rows.
Each is to be answered by one query only.

1. languages that are spoken by 100% of a country.  Note: this is not an empty set.

2. number of languages that are "spoken" by 0% of a country. (whatever that means...)

3. the number of different such languages (i.e. those that are "spoken" by 0% of a country).

4. the one that is "spoken" by 0% of a country in the most countries and the number of countries 
it is "spoken" in

5. how many countries are in the countrylanguage table.

6. what are the countries of the country table that are not in the countrylanguage table.
hint: use a subquery.

7. top ten countries in terms of number of languages spoken in them, ordered primarily by the number
   and secondarily by countrycode.

8. how many countries have some (i.e. any) form of English spoken in them

9. length of the longest language name.

10. the row(s) containing that longest language name

11. the number of different languages.

12. number of countries that have an official language that is "spoken" by 0 percent

13. the country with the lowest average percentage of speakers per language
of languages that have non-zero percentages.  and this lowest percentage.

14. top ten countries with the most number of official languages.