SQL LAST_VALUE with subquery
SQL LAST_VALUE with JOIN clause
SQL LAST_VALUE with HAVING clause
SQL LAST_VALUE with WHERE clause
SQL LAST_VALUE with DISTINCT clause