0 - 1 of 1 tags for MAX() OVER ()

Hi experts,
Have a SQL that goes something like this