Partition by
You have been given monthly temperature data for various weather stations and are conducting an analysis on the minimum temperatures across the stations.
You're interested in grouping the data by the station_id and comparing the monthly minimum temperature with the minimum overall temperature of that station for the year 2010.
Bu egzersiz, kursun bir parçasıdır
Time Series Analysis in PostgreSQL
Egzersiz talimatları
- Use a window function to find the minimum
t_monthly_minthat is grouped bystation_id, filtered for the year 2010.
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
-- Use a window function to find the minimum temperatures
SELECT
station_id,
year_month,
t_monthly_min,
___
FROM temperatures_monthly
WHERE ___;