[Feature Request]: support first_value()/last_value() over ()

[LiSong0214]

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

first_value(s) over (partition by course order by score desc)
last_value(s) over (partition by course order by score desc)

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response