FIRST_VALUE()
/ LAST_VALUE()
window functions to get the first / last values of multiple columns, and am feeling lazy / don't want a second layer of code from enumerating the rows with ROW_NUMBER()
before filtering on the results of that expression, and performance doesn't matter much in the use case.