SELECT department, ROUND(100.0 * used / available) AS occupancy_pct FROM his_bed_census_week -- read-only view WHERE week = '2026-W47' ORDER BY occupancy_pct DESC;