Learn how to use the ROW_NUMBER() windows function to generate a unique ID. Problem: You have a table

Problem We want to compare two moving averages in SQL. We’ll use window functions to do this, as

Problem You want to remove duplicates in SQL. You know it is easy to find duplicates using GROUP