1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Time Series Analysis in PostgreSQL

Connected

अभ्यास

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.

निर्देश

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