Inline single-use temp variable.
Refactor so that it's more obvious how the holiday calculation works. It's still wrong, but it's clearer now.
[Neil, Chris] Use an aggregate query to optimise the head teachers absenteeism count.