DENSE_RANK() over (order by forw_dens_per_5sec DESC,end_time_5sec-timepoint,timepoint) rank,
COUNT(*) over (order by timepoint range BETWEEN CURRENT row AND interval '5' second following ) forw_dens_per_5sec,
MAX(timepoint) over (order by timepoint range BETWEEN CURRENT row AND interval '5' second following ) end_time_5sec
METAR code is regulated by the World Meteorological Organization in consort with the International Civil Aviation Organization. In the United States, the code is given authority (with some . national differences from the WMO/ICAO model) under the Federal Meteorological Handbook No. 1 (FMH-1), which paved the way for the . Air Force Manual 15-111  on Surface Weather Observations, being the authoritative document for the . Armed Forces. A very similar code form to the METAR is the SPECI. Both codes are defined at the technical regulation level in WMO Technical Regulation No. 49, Vol II, which is copied over to the WMO Manual No. 306 and to ICAO Annex III.