1. Lära sig
  2. /
  3. Courses
  4. /
  5. Time Series Analysis in PostgreSQL

Connected

exercise

Temperature percentile

You are working for a national weather agency and have been tasked to create a report that indicates what percentile a month falls in based on its hottest temperatures. Knowing the percentile will help rank the hottest months.

You will be looking at weather data from California, CA.

Instruktioner

100 XP
  • Rank the t_monthly_max for the state of CA and have this ranking be a percentile.