Description
Exercises for All Students
Exercise 1:
Create a relation that joins the observed temperature data with the station name data, so the location
name will be included within each observation in the relation.
Rather than show the entire relation, use the LIMIT keyword to show 5 entries from the relation (see
the end of the Sorting Data section on page 408 of the text to see how to use LIMIT).
Exercise 2:
Obtain the number of trusted temperature observations and the minimum, average, and maximum
temperatures by station for each station from in the data. Show the first 10 results.
Note: The data has already been filtered for missing temperatures and bad quality codes, so you do not
need to do filtering to get trusted observations.
Exercise 3:
For the station with the lowest minimum temperature, obtain the name, the minimum, average, and
maximum temperatures for each year from 1920 to 1929, and show your results.
Note: Not all stations have temperature observations for every year, thus the station with largest
temperature might not have results for every year.
Additional Exercise for Graduate Students
Exercise 4:
Obtain the maximum temperature deviation above the average (max temperature – average
temperature) and the maximum temperature deviation below the average (average temperature – min
temperature) for each recorded station location for the period from 1920 to 1929 (you do not need to
show this result).
Programmatically find the station name and maximum temperature deviation above the average for the
station with the largest maximum deviation above the average for the time period (ORDER and LIMIT
should be useful for getting this information from the range data). Then obtain that station’s maximum
temperature deviation below the average by year for each year from 1920 to 1929.
Note: Again, not all stations have temperature observations for every year, thus the station with largest
temperature range might not have results for every year.
