The Scenario:

There is a database that stores the average monthly temperature of each country dating back to 1901. The database can be created by running the following script: WorldTemps_CreateScript.sql

*Note: If you ran the script from Part 1, then you do not need to create the database again.

The Request:

You work for the National Center of Environment Information and have been tasked with answering specific questions pertaining to global warming using the world_temps table .

Requirements and Information:

1. What is the maximum and minimum average monthly temperature per country?
2. What is the average monthly temperature per country for the years 1901 2015?
3. What is the yearly temperature difference for the USA from 1950 - 2015?
4. What is the average winter temperature (Months: December - February) and average summer temperature (Months: June - August) per year for the Great Britain from 2000 - 2010?

What to Submit:

Upload a completed lab report answering all questions and including the scripts that pulled the data.