Window functions are incredibly powerful Data Analysis & SQL SQL Window Functions: RANK and Running Totals
