MySQL Lab Assignement #4

Due: 3/3/2010

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%.