How to select an event that has max attribute

[Guoqin Zheng]

Hi Flink Community,

I am curious what the recommended way is to select the event with a max
attribute value with SQL api.

For example, I have an event stream like:

{
   deviceId,
   locationId
   gauge,
   readtime,  <-- eventTime
}

I want to figure out which device and location has the max gauge over a
5-mins window.

Any advice would be greatly appreciated!

Thanks!
-Guoqin