SQL LAST_VALUE with AS keyword
SQL LAST_VALUE with IS NOT NULL operator
SQL LAST_VALUE with IS NULL operator
SQL LAST_VALUE with LIKE operator
SQL LAST_VALUE with BETWEEN operator