SQL LAST_VALUE with GROUP BY clause
SQL LAST_VALUE with LAG function
SQL LAST_VALUE with LEAD function
SQL LAST_VALUE with NULLS LAST option
SQL LAST_VALUE with NULLS FIRST option