SQL Explanation

Query: Adherence Summary Overview

What it does:
This query calculates the total number of patients, splits them into adherent and nonadherent groups, and computes the overall adherence rate.

SQL Breakdown:

• COUNT(*) AS total_patients: Counts all rows (i.e., total number of patients in the dataset).
  
  

• COUNT(*) FILTER (WHERE adherence = 'ADHERENT') AS adherent_patients: Counts only patients labeled as "ADHERENT."
  
  

• COUNT(*) FILTER (WHERE adherence = 'NON-ADHERENT') AS nonadherent_patients: Counts only patients labeled as "NON-ADHERENT."
  
  

• COUNT(*) FILTER (WHERE adherence = 'ADHERENT') * 1.0 / COUNT(*) AS overall_adherence_rate: Calculates the proportion of adherent patients (as a decimal rate) by dividing adherent patients by total patients.
  
  

Output Summary:

• Total Patients: 24,084
  
  

• Adherent Patients: 9,669
  
  

• Nonadherent Patients: 14,415
  
  

• Overall Adherence Rate: ~40.1%
  
  

Why this matters:
This high-level summary shows that only about 40% of patients adhere to their medication, which highlights a significant gap in adherence. This sets the stage for deeper analysis by demographics, comorbidities, or interventions.

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