SELECT Number_of_active_patients, Number_of_active_patients-Number_of_patients_on_medication AS Number_of_patients_not_on_any_medication, (Number_of_active_patients-Number_of_patients_on_medication)/Number_of_active_patients*100 AS Percentage_of_patients_not_on_any_medication FROM (SELECT COUNT(*) AS Number_of_active_patients FROM demographic WHERE patient_status='AC') AS Count_of_active_patients, (SELECT COUNT(DISTINCT demographic_no) AS Number_of_patients_on_medication FROM drugs WHERE DATEDIFF(end_date,CURDATE())>0) AS Count_of_patients_on_medications;