Writing a sub-query

As we develop our skills in the Databricks environment, we will want to start performing some more advanced analyses on our datasets. In this exercise, we will be practicing using sub-queries to analyze more of our insurance data.

Imagine the following scenario:

You are a data analyst in your compensation team at a national insurance company. You have been asked to identify how many large claims (>$1000) each employee has had, as that will factor into end of year bonuses.