SQL LAST_VALUE with NOT IN operator
SQL LAST_VALUE with IN operator
SQL LAST_VALUE with wildcards
SQL LAST_VALUE with logical operators
SQL LAST_VALUE with comparison operators