The query worked fine this time. Here's one thing you should remember: while
FIRST_VALUE() works well with the default window frame,
LAST_VALUE() needs an explicit definition of the right window frame to actually make sense.
Of course, you can order by one column and return the other:
LAST_VALUE(Budget) OVER(ORDER BY OpenDate ASC ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS MostRecentBudget
Here we show the budget of the most recent website (not the biggest budget).
How about trying to write your own example query? Are you ready?