Practice: SQL if/case and procedure

1. Add 10 to the GNP For all the countries in North America and 5 to the rest of the countries in the Country table (using IF statement)

2. For all the countries in North America In the Country table, add 2 to the GNP of the countries in the region of "Caribbean", add 5 to the GNP of the countries in the region of "Central America", and add 10 to the GNP of the countries in the region of "North America" (using CASE statement).

3. Create a procedure to add certain years to lifeexpectancy to the countries in certain continent in the Country table.

4. Create a procedure to display the official language of certain country in the CountryLanguage table.

5. Create a procedure to display the countries that have the population more than a certain number in a certain continent in the Country table.

The World Schema/DB can be downloaded from https://dev.mysql.com/doc/index-other.html