Creating a table of large premium claims

In this exercise, you will combine different data engineering tasks together to create a new table. This is a typical scenario as a data engineer, where you will need to combine several different data engineering concepts together to achieve your end goal. Take the following scenario into consideration:

The VP of Claims Adjustments wants to better understand some of the larger claims that your company has received. The VP considers any claim with a premium of $100 or more as a "large claim" for this analysis. They want you to create a separate table that they can run a report against that meets the following criteria:

• Has a total count of unique customers by ID.
• Breaks down the count by the kind of insurance coverage they have for the claim.
• Limits the dataset to only rows where the premium amount is greater than or equal to $100, as a proxy for identifying larger claims.