1. Learn
    2. /
  2. Courses
    3. /
  3. Time Series Analysis in PostgreSQL

Exercise

Calculate yearly average temperature

As a data analyst you may be called upon by a colleague to perform an ad hoc query that helps them perform their role more effectively or to help satisfy their curiosity about data that is important to them. In this scenario, you are a data scientist at a weather station. The weather station manager wants you to calculate the yearly average temperature for each weather station, by averaging the monthly average.

Instructions 1/2

undefined XP
    1
    2
  • Calculate the yearly average of t_monthly_avg for each weather station; display the year as a truncated timestamp: 2021-01-01 00:00:00+00:00.