SQL Explanation

Query: Average Contributions and Claims by Adherence Status

What it does:
This query compares the average annual contribution and average claim amount for patients based on whether they are adherent or non-adherent to their statin therapy.

SQL Breakdown:

• AVG(annual_contribution) AS avg_contribution: Calculates the average amount each patient contributes annually.
  
  

• AVG(annual_claim_amount) AS avg_claim: Calculates the average amount claimed annually.
  
  

• GROUP BY adherence: Splits the results between adherent and non-adherent groups.
  
  

Output Summary:

Adherence Status

Avg Contribution

Avg Claim

NON-ADHERENT

5,901,194.82

871,295.78

ADHERENT

6,131,415.22

339,856.65

Insights:

• Adherent patients contribute slightly more annually than non-adherent ones.
  
  

• However, non-adherent patients generate more than double the claim costs on average.
  
  

Why this matters:
This strongly suggests that adherence leads to lower healthcare costs. Non-adherence results in higher financial burden, likely due to complications or additional treatments. This is a key metric for cost-benefit discussions and could support business cases for adherence improvement programs.

Note: This dataset is synthetic and used strictly for educational purposes. It does not reflect real patient data.