NTH_VALUE & Other Advanced Functions: Mistakes

NTH_VALUE without proper frame

NTH_VALUE(..., N) OVER (... ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)

Default frame may not include Nth row. Specify full frame.

Specify frame for NTH_VALUE

High

May not reach Nth row