Using a window function

In the previous exercise, we learned how to use a sub-query to provide a more complex tool for our analyses. In this exercise, we will be continuing our advanced analyses and will use window functions to help us. As a reminder, window functions allow us to calculate something over a finite selection of data rows.

Imagine the following scenario:

You have been tasked to figure out which are the largest claims in each state. Your executives want to be able to filter the top N claims for each state, and want this information to be readily available in their dashboards.

This is a great use case for the RANK() window function!