Window Function สำหรับค่าสูงสุด

SELECT fk_monitoringlocation,
       -- Explicitly convert sample_date to a DATE
       ___(sample_date AS ___) as date_sampled,
       characteristic_measurementvalue,
       -- Find the max measurement
       ___(___) ___ (
            -- For each year window based on the sample date
            ___ BY DATE_PART(___, ___(___ AS DATE))
       ) as yearly_max
  FROM public_intro_redshift.idaho_samples
 WHERE characteristic_name = 'Alkalinity'
 ORDER BY date_sampled DESC,  
          fk_monitoringlocation;