title: Window functions in SQL: why are they called window functions?
body: <p>I understand window function but don't understand why they are called window functions. When we say the &quot;window&quot; is it both the partition and the order by clauses?</p>