CIS 363 Lab Assignement #3

Due: 2/22/2011

Turn in SQL command and first ten lines of the output only.

1.  Display country code, name, head of state, population, Capital data from the country table in Africa ordered by GNP in descending order.

2.  List all cities for Canada order by population in descending order.

3.  List all languages for USA order by percentage in descending order.

4.  Explain the difference between DELETE and TRUNCATE.

5.  Write the correct ALTER TABLE command to add a 'mayor' column to the city table.