MySQL Lab Assignement #4
Turn in SQL command and first ten lines of the output only.
1. List all languages that are an official language in at least five countries and a count of all countries that have it as an official language order by the count. Use the countrylanguage table.
2. Add the following cities to the city table: Gotham, Metropolis, and Bedrock.
3. Now delete those three cities.
4. List all US States along with a count of cities and the total population for all cities in that state, also provide a rollup total for the USA.
5. Increase the population for each city in Nevada by 10%.