Using windows and sub-queries together

Now that we know how to utilize more advanced techniques in the Databricks environment, let us put them into practice. Imagine the following scenario:

The Director of Vendor Relations is working on prioritizing funding for the various vendors your company works with for insurance claims. They want to understand which vendor has processed the most homeowner claims for your customers, and then provide additional funding for the best vendors.

In this case, we will need to use window functions and sub-queries in the same query!