Join Policy, Customer, and Campaign Tables

How would you use JOINs to combine policy, customer, and campaign tables?

For this exercise, the provided policy_customer_campaign table contains the policy, customer, and campaign attributes needed for the result. Write a query that returns active policies associated with a campaign.

Output

1. One row per qualifying policy
2. Columns: policy_id, customer_id, customer_name, campaign_id, campaign_name, and premium_amount
3. Exclude inactive policies and rows without a campaign
4. Order by premium_amount descending, then policy_id ascending