Question: The data dictionary for the assignment is located here: Worlddata Database - Data Dictionary i How to do it ? The scenario is that you

The data dictionary for the assignment is located here:
Worlddata Database - Data Dictionary
i How to do it?
The scenario is that 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. You will be using your experience in creating SQL queries to complete the following:
List the total number of months where any country's average monthly temperature exceeded 80F. How many records are listed?
List the months each country had an average January temperature below freezing (32F). How many records are
 The data dictionary for the assignment is located here: Worlddata Database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!