only shows the rows from the inner query having
    <code class="literal">rank</code> less than 3.
   </p><p>
    When a query involves multiple window functions, it is possible to write
    out each one with a separate <code class="literal">OVER</code> clause, but this is
    duplicative and error-prone if the same windowing behavior is wanted
    for several functions.  Instead, each windowing behavior can be named
    in a <code class="literal">WINDOW</code> clause and then referenced in <code class="lit