Sha256: 0e4b3fe64609d44cfbcba164a70291a92aa890e335bb7577d5a5a2bbf88477e5
Contents?: true
Size: 476 Bytes
Versions: 173
Compression:
Stored size: 476 Bytes
Contents
SELECT
units.name,
count(stats.id) AS patient_count,
0 as percentage_hb_gt_100,
0 as percentage_urr_gt_65,
0 as percentage_phosphate_lt_1_8,
0 as percentage_access_fistula_or_graft,
0 as avg_missed_hd_time,
ROUND(100*SUM(number_of_sessions_with_dialysis_minutes_shortfall_gt_5_pct)/COUNT(stats.id),1)
as pct_shortfall_gt_5_pct
FROM (hd_patient_statistics stats
JOIN hospital_units units ON ((units.id = stats.hospital_unit_id)))
GROUP BY units.name;
Version data entries
173 entries across 173 versions & 1 rubygems