Was this helpful?
Example
For this example, let’s calculate the following:
Max daily temperature range, grouped by city, during the first 4 days of July 2012
Let’s assume that we are given a data set containing the following fields:
Field
Description
City
The city where the temperature readings were taken
Date
The date the temperature readings were taken
Low
The low temperature for the given date
High
The high temperature for the given date
A few rows from the data set might look like this:
City
Date
Low
High
Austin
2012-07-01
73
89
Boston
2012-07-01
71
91
Boston
2012-07-05
68
78
Last modified date: 06/14/2024