Creating a large claims table

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. 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 the claims that are greater than or equal to $100.