Hello, here is a puzzle that makes perfect use of the FIRST_VALUE, LAST_VALUE, LAG, and the MIN functions. For the following dataset, you need to find the difference between each player's first score against the current score, as well as their last score against the current score. If their score improved from their previous score, … Continue reading First and Last Values