Is there a query available to calculate change success rate? 

Total # of complete changes (per month, per year) / Total # of successful changes (change closure code)